General discussion
August 15, 2006 at 08:35 PM
theandoman

An Access delete query with a composite key.

by theandoman . Updated 20 years, 2 months ago

I ran into a little problem with a project of mine. I need to run a delete query, called up by a form, to delete records using a composite key. I can’t find the syntax for this anywhere.

The form has a text box for entry of the Last name, First name (my composite key in that format). Ex.- you enter name (Smith, Joe) in the text box and click on a button labeled delete. This calls up the delete query to remove that person’s listing from our phone directory database.

I can’t find the VBA code for this with the composite key. Is the syntax for this any different?

Thanks in advance.

This discussion is locked

All Comments