How to do a Dlookup on the table before inserting

  • Thread starter Syphonics via AccessMonster.com
  • Start date
S

Syphonics via AccessMonster.com

In my order form I have a button name "Total Amount". Upon click, different
fields values from my order form will be inserted into a table name
"Transactions"

One of the field that will be inserted is the InvoiceID field.
This InvoiceID field from my order form will be inserted into the table
"Transactions" under a field name "Descriptions"
Can I do a check on my table "transactions" under the field name
"descriptions" for the invoiceID upon clicking on the button "Total Amount".
Hence the command will be before the inserting.
And I need to use a wildcard because the "Descriptions" has a few other field
values as well.

Thank you
 

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