I have an access for that looks up the value of another field and returns a list of records from another table where the 2 fields match. But when I go through the form, it only does the query once so the pulldown menu is always the same utill I close the form and open it on another record and then pull it down again. How do I have it refresh everytime I goto a new record?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Refreshing the lookup
- Thread starter fiber0pti
- Start date
LonnieJohnson
Programmer
On the form's Current Event requery the combo box:
Private Sub Form_Current()
ComboBox.Requery
End Sub ljprodev@yahoo.com
Professional Development
MS Access Applications
Private Sub Form_Current()
ComboBox.Requery
End Sub ljprodev@yahoo.com
Professional Development
MS Access Applications
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question