having problems placing (2) combo boxes on my form

[RJ45]

I ‘m still having problems placing (2) combo boxes on my form.
The first one works fine but the second is not.

I keep getting a “Name?” on the fields.
I have attached my DB; please take a look at it.

Thanks.

 

[Mile-O]

Your form is bound to the same recordsource as the first combobox.

The details following the second combobox are set to a different table.


A form can only have one recordsource at any one time. So, the fields under the second combobox are trying to reference fields in the form's current recordsource (the stuff under combobox one) but can't find them - so, it's telling you it can't find fields in the Commercial Clients table with the names: Extension, H_Floor, and H_Room.

 

[RJ45]

?

So how can i get it to work with 2 combo boxes.

 

[Mile-O]

Like this:

 

[RJ45]

Thanks, but how did you get it to work

Thank you for your help BUT how did you get it to work?

 

[Mile-O]

• I removed the form's RecordSource (the table it was bound to);
• I removed the code on the AfterUpdate() event of the first combobox;
• I removed the current ControlSources of the six textboxes under your two comboboxes;
• As your combos' RowSource were obtaining their lists from two tables I fixed these individually to hold all the information from each table in each combo respectively;
• I changed the ColumnCount that each combo had from 1 to 4 to reflect the number of fields in each table;
• I set the ColumnWidths to 2.54cm;0cm;0cm;0cm so that only the first column would be visible in each combo;
• In each textbox I referenced the appropriate column in the textbox's ControlSource with =[ComboName].Column(1) where 1 is the second column, 2 the third, and 3 the fourth. The first column (as selected by the user) is column 0.

 

[RJ45]

Wow, thanks for your help

Thanks for your help.

 

[RJ45]

I recreated the combo boxes

I just created 4 more combo boxes the way you instructed me to, and they all worked.

Thanks,

 

[Mile-O]

No probs.