Continuous form with combo box

G

Guest

I have a continuous form that has a combo box. Is it possible to change the
selection list to be different as the focus moves from row to row?
The rows represent audit findings and depending on the audit finding the
selection list for corrective action (the combo box) will be different.
Obviously, I will want to keep previous selections even though they may be
incompatible with the selections for a different row.
 
S

strive4peace

A combobox can only have one RowSource. If you want to
limit the list depending on the record you are on, use the
GotFocus event of the combo to write the SQL specifying the
criteria. Use the Loistfocus event to make the SQL show
everything.


Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 

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

Prevent duplicate selection from combo box on continuous form 4
Need combo box to refresh when moving to new record 2017 1
2 combo boxes 2
OnChange combo box 2
Retain combo box order 1
Test for a Combo Box empty or not... 4
Need Help with Subform Combo Box! 1
Different behavior with list box and combo box 3

Top