filling drop-down for specific record

C

Craig

I have a form that is displaying all the records from a
table in dataset view. I have created 2 drop-down boxes to
simplify data entry. The first one chooses a parameter.
Based on this parameter, the 2nd drop-down box is populated
with values from another table, based on a query. I can get
this to work to a certain extent, but unfortunately, if the
user returns to the already populated for and wants to
change the value in the 2nd drop-down, they first have to
re-select the parameter in the first drop-down.
So how do I get the query to return only the records that
belong to the particular parameter without having to first
reselect the parameter?

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Paragraph numbering in Word 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Linking drop down boxes 3
dependent, multiple variable, drop down list 2

Top