Re: Requerying a pop up form to display in the main form

Tech-Archive recommends: Fix windows errors by optimizing your registry

As I indicated in my first reply, this can be done by adding a requery step
to the code that is opening the form. Can you post the code that is run when
you click the button to open the popup form?

--

Ken Snell
<MS ACCESS MVP>

"Jennifer P" <JenniferP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C2B1CC9-7A8E-497B-87F3-84EDBE378A80@xxxxxxxxxxxxxxxx
> Okay my pop up is working but the main form that the information goes to
> is
> not updating with the information from the pop up unless I close it and
> open
> it
>
> "Ken Snell [MVP]" wrote:
>
>> How are you opening the popup form now?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Jennifer P" <JenniferP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:AD0E0DDA-665C-4557-996A-7C0C5694CD4E@xxxxxxxxxxxxxxxx
>> > Okay forgive me I am not that advance with Access YET...
>> > I am not sure what "dialog mode" refers to
>> >
>> > "Ken Snell [MVP]" wrote:
>> >
>> >> In the code that opens the popup form, after the line that opens the
>> >> form
>> >> (in dialog mode, right?), put a requery step for your current form.
>> >>
>> >> Something like this:
>> >> DoCmd.OpenForm "popup form", , , , , acDialog
>> >> Me.Requery
>> >>
>> >> --
>> >>
>> >> Ken Snell
>> >> <MS ACCESS MVP>
>> >>
>> >> "Jennifer P" <JenniferP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:B1018B9D-7220-4F46-A794-CEB70F6A0348@xxxxxxxxxxxxxxxx
>> >> >I have a form call Daily Dispatch Log its table is also Daily
>> >> >Dispatch
>> >> >Log.
>> >> > I have a pop up form "Quick Call" that opens to a new record if I
>> >> > am
>> >> > in
>> >> > the
>> >> > Daily Dispatch Log and allows me to put another record in with.
>> >> > (Officer,Call
>> >> > Type, Location, License, State, On Scene). I created the pop up
>> >> > form
>> >> > so
>> >> > if I
>> >> > was in a call I could quickly add another record with out having to
>> >> > leave
>> >> > the
>> >> > screen I was in. I need help in setting this pop up form to requery
>> >> > the
>> >> > information on the Daily Dispatch Log so I am not having to close it
>> >> > out
>> >> > to
>> >> > see it on the main form "Daily Dispatch Log"
>> >> >
>> >> > Thanks in advance Jen
>> >>
>> >>
>> >>
>>
>>
>>


.

Quantcast