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
 
Top