Synchronised Combo Boxes

[redblaze]

how can i synchronise 2 combo boxes from the same table?? what i have at the moment is, 2 fields, equipment name and equipment size. just say for example i click equipment name-crutch, i want only a set list of sizes for the crutch to appear in the second combo box. how can this be done?

thanks for your help.

 

[jwindon]

Yes it can be done.

In the row source of the second combo you need to hit the query builder and select both field names in the grid. The criteria should be set under the first combo to something like:

Forms!frmName!ComboBoxName

I've given you minimal information. There is a lot more on MS Knowledge base.

 

[redblaze]

hi, the code u gave me didnt work. thecombo box just appears blank even when there is nothing selected in the first combo..

is there any other way, or VB code to make this task easier?

thanks.

 

[jwindon]

I don't think you set the query correctly.

There is no code needed here.

Would you like a demo?

 

[redblaze]

that would be very helpful, thanks.