Default Textbox Value

F

FerryMary

(I know I should have been able to find this, sorry)

2 forms involved.
frm1 (based on tblPMPrimary)
frm2(based on tblPMResults-created by AppendQuery)

frm1 has append query button to bring up current worklist for location.
frm1 also has button to bring up frm2, which is based on worklist-includes
results and foreign key for tblPMPrimary
The button to bring up frm2 uses equipmentID to link the forms. I need the
worklist Primary Key to be the default value of same field in frm2.

Is there a way to copy value of frm1.PMPrimary(textbox) to frm2.PMPrimary
(textbox)? Currently it just shows '0'?

Thanks so much
 
M

Maurice

If the form is still open when you open the second form you can push it like:

docmd.openform "frm2"
forms!frm2.PMPrimary = me.pmprimary

hth
 
F

FerryMary

Thanks. I forgot an important fact. I will perform multiple checks on each
peice of equipment. So when frm2 is pulled up, since I have it based on
equipment, it will also pull previously completed checks. To counter that, I
had frm2 set to open with criteria that 'pmpmrimary' = 0 (for new records
only).

So do I need to update the textbox 'After Update' and can you suggest how?
I guess this question is not about a default value afterall...

And yes, frm1 is still open when frm2 opens.
Sorry for being so thick on this and thanks.

Mary

https://accountservices.msn.com/Ema...88zQLNKBtIgaiBRiIdETLGx621ap&lc=1033&urlnum=0
Sorry for being a pain. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top