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.