filter data for error free data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top