PC Review

Thread Tools Rate Thread

How to Keep Combos requeried when viewing and editing records.

New Member
Join Date: Apr 2010
Posts: 1
      17th Apr 2010
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
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: combo box that updates outside table and then needs to be requeried John Vinson Microsoft Access Forms 0 10th Dec 2005 02:44 AM
Re: combo box that updates outside table and then needs to be requeried jleckrone@hotmail.com Microsoft Access Forms 0 2nd Dec 2005 09:08 PM
subforms getting requeried unnecess Malcolm Cook Microsoft Access ADP SQL Server 1 6th Oct 2005 08:28 AM
How to get requeried main form to keep subform in same place doyle60@aol.com Microsoft Access VBA Modules 3 11th Jul 2005 07:02 PM
Move fr model form bk to requeried main form Bonnie Microsoft Access Form Coding 0 14th Apr 2004 06:16 PM




All times are GMT +1. The time now is 03:00 PM.