If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subform on an unbound main form | Chuck | Using Forms | 1 | February 2nd, 2005 11:32 PM |
Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |