Requery DropDown on New Record

[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

 

[Nonprofit Tech via AccessMonster.com]

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.

 

[Alan Z. Scharf]

Thanks very much for your reply.

That sounds like it will work.

Regards,

Alan