How to Keep Combos requeried when viewing and editing records.

Joined
Apr 17, 2010
Messages
1
Reaction score
0
I have a CustomerID Combo on my form and in the after update event it successfully requeries a ContactsID Combo on the same form.

My question is when later viewing or editing the records - for example using the navigation buttons and selecting a record the ContactsID Combo although it shows the correct selection initially made, say I wish to change the contact to another person, the ContactsID Combo will display all possible contacts to choose from and not just the ones related to the CustomerID.

What code would I need to use so that when I go back and view/edit a Customer the ContactsID is requeried just to show all possible contacts just for the CustomerID.

At the moment when editing the record I am manually selecting CustomerID which fires the After Update Event to requery the ContactsID Combo

Many thanks in advance
Andrew
 

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

Top