Irritating Combo Boxes

[Warbuckle]

Hello,

My problem is as follows:

I have built a table with 5 fields

Destination Time Broker Unit# Trailer#

I have built a form for data entry based on this table and it'd fields.

I have put combo boxes for the first 4 fields, the last field is entered directly by the user.

The info in the first 4 fields, "combo" boxes comes from 4 different tables.

My problem is that when a value is selected for the first combo box "Destination" it populates all the corresponding Destination combo boxes with the same value.

Same in the other 3 drop down combo boxes.......


Any assistance appreciated.
William

 

[Elana]

Take a look at this MS Knowledge Base article - it might help you understand what's going on and how to fix it.

208866

HTH
Elana

 

[Warbuckle]

Thanks for the info,
it does not not answer my problem, I can accomplish the same thing in the table on which the form is based on by using the lookup wizard in table design view.

Seems like the same should be possible from within the form itself, why should all "destination" combo boxes autofill depending on the choice in the first?............


Well, I suppose I will find a work around but this has been driving me nuts for a week now..................lol


Regards
William