filter data for error free data entry

P

Pedro

In a data entry form. I have a pull down box to select
Object(7000,8000,9000)from a lookup table OBJECTS
Say I select 7000...then in the next pull down I select Dept(1, 2, 3 )from
lookup table DEPTS..say select 1
On the third pull down....I would just like to see the 7000 for dept 1.

I tried several ways...select object, select dept. but I get every account
number all 7000, all 8000, and all 9000...... with object 7000, dept 1, third
box should show only accounts corresponding...how do I do that?
 
H

Hansford cornett

This can be done easily however been a while since I did it. Have to look at
some code and get back with you unless you have already figured it out.

I think it is covered in the help function if not it is covered in almost
all books FREE ANSWERS.COM may also give you this.

Get with you tomorrow if I don't hear that you already have this working.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering for data entry 1
Data Validation 1
Linking data in MS Word into Excel 5
Copy Excel Function from a Cell Through a Function 0
extract of data with 3 different conditions? 10
using a filter to facilitate date entry 0
Data Entry Form. 3
Particulars data Filter from sheet 1 to sheet 2 automatically 4

Top