Re: data update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Stuart McCall" <smccall@xxxxxxxxxxxxxxx>
Date: Thu, 22 Nov 2007 13:47:47 -0000

"angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E482A145-D0F5-48A0-87AC-4A65A94E4E11@xxxxxxxxxxxxxxxx

where do i have to put the code or macro to
requery the combo? on the on click event for example?

You need the requery to occur when you close your input form(s). If you are
opening your form with DoCmd.OpenForm, using acDialog as the WindowMode,
then you should do the requery immediately following that. If not, then
place some code like this in the input form's Close event procedure:

Forms!MyFormName.ComboboxName.ReQuery

substituting your actual form name and combo name, of course.

.

References:
- Re: data update
  - From: Stuart McCall

Prev by Date: Re: Restricting access to database using forms
Next by Date: help with coding - for creating secure login forms
Previous by thread: Re: data update
Next by thread: KeyDown Event and vbKeyNumpad (?)
Index(es):
- Date
- Thread

Relevant Pages

Re: Adding data to a dro-down list
... Use the AfterUpdate event of the form where you entered the lookup data to ... Requery the combo on the previous form. ... (You may need to undo the combo first.) ... > also added the code for opening a form where I can add the new data to the ...
(microsoft.public.access.formscoding)
Re: Adding data to a dro-down list
... Use the AfterUpdate event of the form where you entered the lookup data to ... Requery the combo on the previous form. ... (You may need to undo the combo first.) ... > also added the code for opening a form where I can add the new data to the ...
(microsoft.public.access.forms)
Re: Refresh DB
... connection than closing and opening it? ... you can use Requery, which is the same as if you would call Close and ...
(borland.public.delphi.database.ado)
Re: Requerying a pop up form to display in the main form
... As I indicated in my first reply, this can be done by adding a requery step ... to the code that is opening the form. ... you click the button to open the popup form? ... <MS ACCESS MVP> ...
(microsoft.public.access.forms)
Re: Datasheet appears after requery
... use the event procedure - at least I did that right.) ... The requery macro s now working. ... but the cursor still returned to the first record. ...
(microsoft.public.access.forms)