<div>
You don't actually need to do the dLookup(). &nbsp;Just open the form normally with a where argument. &nbsp; If the record is found, the form will open to the found record. &nbsp;If it wasn't found, the form will open to a new record. &nbsp;So,<br />
DoCmd.OpenForm &quot;frmRequestForPickup&quot;, acNormal, ,&quot;[PetID]=&quot; &amp;&nbsp;me.txtPetID , , acWindowNormal<br />
<br />
Should do it.
</div>


You don't actually need to do the dLookup().  Just open the form normally with a where argument.   If the record is found, the form will open to the found record.  If it wasn't found, the form will open to a new record.  So,
DoCmd.OpenForm "frmRequestForPickup", acNormal, ,"[PetID]=" & me.txtPetID , , acWindowNormal

Should do it.

<div>
<div class="content wysiwyg-content">
I have a 2nd form which opens from a command button on a 1st form:<br />
<br />
DoCmd.OpenForm &quot;frmRequestForPickup&quot;, acNormal, , , acFormAdd, acWindowNormal<br />
<br />
if the form has never been filled out before.<br />
<br />
But if the form has been filled out before I want it to open and show that record which I suppose means it can't open with the acFormAdd in the code.<br />
<br />
The way to determine if the form has been filled out before and there is a record entered already is via a field named &quot;PetID&quot;. &nbsp;If the table has a record with PetID matching the field txtPetID in form 1 then display the already existing record.<br />
<br />
How?
</div>
</div>


I have a 2nd form which opens from a command button on a 1st form:

DoCmd.OpenForm "frmRequestForPickup", acNormal, , , acFormAdd, acWindowNormal

if the form has never been filled out before.

But if the form has been filled out before I want it to open and show that record which I suppose means it can't open with the acFormAdd in the code.

The way to determine if the form has been filled out before and there is a record entered already is via a field named "PetID".  If the table has a record with PetID matching the field txtPetID in form 1 then display the already existing record.

How?

How open form with certain circumstances

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.