Open form from another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top