Open form from another

J

J

I have a form(frmMfg) based on tblPartMfg and I want to open another
form(frmTesting) based on tblPartTesting for the same PartNumber. If a record
for the PartNumber doesn’t exist in tblPartTesting then I want to open
frmTesting to the status where I can enter a new record. Can someone provide
sample code a newbie can use? Thanks a bunch.
 
W

Wayne Morgan

You could open the form filtered using the criteria you mention. If the item
exists, it will show, if not, you'll simply be at a new record.

Example:
DoCmd.OpenForm "Form1",,,"[PartNumber]=" & Me.txtPartNumber
 

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

Similar Threads

Assigning specific record data to fields on a form Access 2003 0
needing UPDATE assistance 8
Problem Passing Parameter from Form 3
Display Status on Form 2
Autonumber field in Excel that behaves the same as Access 0
How do I clear a form? 0
generate an ID for a record in a subform based on main form ID 2
Copy Field Value from Form A to Form B isn't working 8

Top