linked combo on my form

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I have a combo on a form that will allow me to choose a
site from the dropdown. This is based on a table and will
create a record when picked of a number relating to the
primary key in the combos source table.

I have another combo which I need to only show values
related to the first combo, almost like saying that
whatever is chosen in the first combo will limit the
second to entries corresponding to the choice. Mine
shows all of the entries not a limited selection.

I have tried a query but it doesnt work or I am doing it
wrong.

Any ideas much appreciated.

With Thanks

Jamie
 
Ken,

Thanks for your reply. Can I send you a copy of the file
to show you whats going wrong?

Jamie
 
I think we should try exchanging information here first.

Post the RowSource of both combo boxes. Post the code/macro that you're
using on the first combo box's AfterUpdate event.
 
Back
Top