Requerying a pop up form to display in the main form

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

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" wrote in message
...
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

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" wrote in message
...
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

How are you opening the popup form now?

--

Ken Snell
MS ACCESS MVP

"Jennifer P" wrote in message
...
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" wrote in message
...
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

Okay I have a command button that opens the form. I created a form and
linked the command. I was sure this was considered a pop up form.

"Ken Snell [MVP]" wrote:

How are you opening the popup form now?

--

Ken Snell
MS ACCESS MVP

"Jennifer P" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

Okay I understand that however I have the main form open all the time it
never closes. The pop form's information is not journaling to the main form
unless I close the main form then I can see it when I reopen it.

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

Let me try asking my question in a different way.

In the form that is open all the time, you do something to cause the popup
form to be opened. Click a button? Post the code that runs in order to cause
the popup form to open.

--

Ken Snell
MS ACCESS MVP


"Jennifer P" wrote in message
...
Okay I understand that however I have the main form open all the time it
never closes. The pop form's information is not journaling to the main
form
unless I close the main form then I can see it when I reopen it.

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

The form that is open is my Daily dispatch Log. It is used to track all
calls. However if i am in the middle of a call I want to press the quick
call button and fill in 5 fields and then close the form. The pop up form
opens to the next availble record in the Daily Dispatch Log. The problem is
when I close the pop up form the Daily Dispatch log goes to record 1 and does
not show that I have added a record. I need it to requery the Daily Dispatch
Log so I can see the call I added with the Quick Call form. Now if I close
the Daily Dispatch Log and reopen it, it shows the record I added.

Jen

"Ken Snell [MVP]" wrote:

Let me try asking my question in a different way.

In the form that is open all the time, you do something to cause the popup
form to be opened. Click a button? Post the code that runs in order to cause
the popup form to open.

--

Ken Snell
MS ACCESS MVP


"Jennifer P" wrote in message
...
Okay I understand that however I have the main form open all the time it
never closes. The pop form's information is not journaling to the main
form
unless I close the main form then I can see it when I reopen it.

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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