Simple Syntax Help

[cvegas]

Have txtbox where user enters vendor invoice number

I want to go into my table dbo_AccountsPayable and see if there is a record where [InvoiceNumber] = the data in the txtbox

If found then I need to open a form and display the data from that record.
docmd openform "Found"

If not found I need to open a different form and insert a new record into the table.
docmd openform "NotFound"

I know it's basic but I am having a DUGH moment

Thanks in advance for any help

[pbaldy]

You can use a DCount() to test for existing records, and open the appropriate form. More info on syntax:

DLookup Usage Samples

[cvegas]

Thank you for your reply.

Could use help with how to determine if the Dlookup found the record or not?

if Dlookup = true then load form1 else load form2

[cvegas]

The textbox on my form where this data would be entered is Named "FindInvoiceFromVendorPage"

Not sure what Criteria is referring to? Is this the Field name?
How do I pass the value in that field to the lookup?

Dlookup("InvoiceNumber","dbo_AccountsPayable","Fin dInvoiceFromVendorPage="""

[pbaldy]

Again, I would use DCount, not DLookup (though you can use DLookup by testing for Null):

If DCount(...) > 0 Then

would indicate a record existed. The criteria syntax is basically:

FieldName = Value

so in your case

DCount("*","dbo_AccountsPayable","[InvoiceNumber] = " & Me.FindInvoiceFromVendorPage)

[cvegas]

Sorry I replied to the message I got in my inbox instead of here
I created a new textbox on the form called "FindInvoice" to test this.
I pasted your syntax in and got the "Expected = error"
I tried several variations to see if I could figure it out but had no luck

FYI the actual field I need to search in the table is named "VendorInvoiceNum" so I subsisted that in your syntax.
Below is a screen shot of my attempts.
I know this should not be this hard but again DUGH!
Hope this one resolves this. Thanks again

[cvegas]

Sorry last message was to long to post screen shot

Private Sub FindInvoice_AfterUpdate()
DLookUp("VendorInvoiceNum","dbo_tblAccountsPayable ","[VendorInvoiceNum]= & FindInvoice")
'DCount("*","dbo_AccountsPayable","[InvoiceNumber] = " & FindInvoiceFromVendorPage)
'The above was sent in email and pasted in here but does not work (says Expected =)
'Below are my attempts to change the syntax which do not work
DCount("*","dbo_AccountsPayable","[VendorInvoiceNum] = ' & FindInvoice")
DCount("*","dbo_AccountsPayable","[VendorInvoiceNum] = & FindInvoice")
End Sub

[pbaldy]

Well, you can't just have the DCount alone like that. You either set a variable to its value:

VariableName = DCount(...)

or test it like my example:

If DCount(...) > 0 Then

When you have it alone like that, Access doesn't know what you want done with it.