Programming carryover in popup form

R

Rachel

I have a form that when the checkbox is checked, another
form pops up. I need several of the values (the primary
keys) to be carried over into that popup form. So, I need
for the checkbox to not only to open a form, but to insert
a record and update some of the "columns" to include that
same information on the main form.

It just seems like it shouldn't be that difficult, but I
can't figure it out.

Can anyone tell me how to do this, or show me an example
of some code?

Thanks!

Rachel
 
M

Marin Kostov

Desing an Update Query, that fits your needs, and name it qryUpdate.
Design a Macro, name it for example macUpdate, and in the Action pane choose
OpenQuery. In Action arguments choose the Query Name. In your case
qryUpdate.
In the Form On Load Event (hit F4, choose the Event Tab, and find the On
Load Event) choose your macro, macUpdate.
 
Top