Continuous form with combo box

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 ;)
 
Back
Top