How to Stop Adding Data, if it not exists???

  • Thread starter Malik via AccessMonster.com
  • Start date
M

Malik via AccessMonster.com

Hi

I have many Tables, Queries and Forms.

Tables are linked well.

Now, I have a Sale Form named "FrmSales" which have many Feilds such as
"CustomerId" and "CustomerName".

When a user enter a Customer Id in "CustomerId" Field its Pulls up Customer
Name Automatically.

Now I want If the User Id not Exist, Its must show an MsgBox...., Instead Of
Add That unexisted Id in Table.


Thanks
 

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

adding records to a from code 0
Launching a Form to Another Form to Create a New Record 12
How to make a foreign column (instead of the foreign key) to be usedby built-in sorting 10
Order Entry type form to add to three tables 12
adding records to an order form 6
adding records to customers order 1
adding records to a form need a code or how to 1
Form design to add data to 3 tables in "Order Entry" style db 1

Top