Access 2000 Form; combo boxes

[Warbuckle]

Hello All,

Quick question,

I made a form from scratch, 5 fields, 4 of these fields the user has the choice from a combo box via 4 different tables, I figured out how to reference the corresponding fields in a table I created after the fact, the data goes into this table now.

My problem is that when I make my first selection from the first combo box it populates all the combo boxes which are refer to that particular table field. All 25 combo boxes populate with the info I select in the first. While the info comes from the same table the info in the 25 combo boxes is dynamic.

Any help appreciated
William

 

[wizcow]

William

It sounds like you may need to add some fields to your main table, although you kind of lost me there.

You mentioned 25 combo boxes in your second paragraph, but only 4 combo boxes in the first paragraph.

Please give us a bit more info.
Try to explain your combo box situation a bit more too.

Tom

 

[Warbuckle]

Sorry about that....

Transportation company; "Trucking"

Form has 5 fileds total for data input, these are:
Setup like this:

Store Del Time Unit# Broker Trailer#
STore Del Time Unit# Broker Trailer#

etc................etc..............for a total of 40 identical sections for data entry.

The first 4 fields are entered via drop down combo boxes, this info is drawn from 4 different tables. The last field "Trailer#" is dynamic, so this is entered directly by the user without the use of a combo box.

as stated in my first post I created a table after the form to take all this data.

My problem is that once the first field is chosen via the combo box it auto-populates all the "Store" fields with what was chosen in the fist Store name..........there are 40 "Store" fields on the form, but all end up being the "same" depending on what was chosen in Store field # 1.

Regards
William