Checking for existing record "Before Update"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I check for an existing record in a SQL database using Access as the
front end? The SQL table has two fields which are both set as keys: Quarter
and Account
 
hi,
a simple select query should do it.
have it promp you for the keys. if the record exists then
the query will show it to you. if not, it displays a blank
query.
 
Back
Top