Requery DropDown on New Record

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

Alan Z. Scharf

1. I have a SQL ADP contacts database with a name dropdown on the main
contact form
for choosing different contacts.

2. How can I get the dropdown list of names update in User A's open app when
User B adds or deletes a contact in his app?

Thanks very much.

Alan
 
First, you must set the timer interval on the form. Under the form's
properties, beneath the "Event" tab, you should see "Timer Interval" which
is by default set to 0. Each interval of 1000 equals 1 second.
For example, to set the timer interval to 10 seconds, enter 10,000 as your
timer interval.

Next, once you have set your timer interval, find the "On Timer" event.
Place the following code under the On Timer event:

me.<YourComboBoxControlName>.requery

This command will occur on its own based upon the setting you place under
your "Timer Interval."

A word of caution...
This will increase your network traffic, and also add to your SQL server's
overhead.
 
Thanks very much for your reply.

That sounds like it will work.

Regards,

Alan
 
Back
Top