Re: Requery DropDown on New Record
From: Alan Z. Scharf (ascharf_at_grapevines.com)
Date: 02/08/05
- Next message: Steve Schapel: "Re: GENERATE ERROR FOR UNIQUE FIELD ON FORM"
- Previous message: DebbieG: "Re: Mouse Wheel Control"
- In reply to: Nonprofit Tech via AccessMonster.com: "Re: Requery DropDown on New Record"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 03:04:15 -0500
Thanks very much for your reply.
That sounds like it will work.
Regards,
Alan
"Nonprofit Tech via AccessMonster.com" <forum@AccessMonster.com> wrote in
message news:f6409e985e0745b190c09071c3e10c98@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.
>
> --
> Message posted via http://www.accessmonster.com
- Next message: Steve Schapel: "Re: GENERATE ERROR FOR UNIQUE FIELD ON FORM"
- Previous message: DebbieG: "Re: Mouse Wheel Control"
- In reply to: Nonprofit Tech via AccessMonster.com: "Re: Requery DropDown on New Record"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
