M
macrobater
First, I'm not a VBA programmer. I have basically created a program with
macros, forms, queries, reports, etc. I've searched all over this site for
an answer specific to my problem and even for areas where non-programmers can
ask their silly little questions. Please forgive me if I've trespassed.
I'm having trouble with a delete query. My intent is to delete records in
two tables with a one to many relationship. The record selected is based on
a form's text box entry. I have first created a select query and the correct
records are shown in both tables when I click on the View icon in the
toolbar. Then, using the toolbar, I change the select query to a delete
query. When I click on the view toolbar, the correct records from both
tables are shown.
The problem is when I click on the "Run" icon or try to open the query from
a macro, Access responds with the following message: "Specify the table
containing the records you want to delete." I've tried a number of different
angles, to no avail. I just don't understand why this message comes up when
the form that is opened and the query both point to the tables that contain
the records I want to delete.
macros, forms, queries, reports, etc. I've searched all over this site for
an answer specific to my problem and even for areas where non-programmers can
ask their silly little questions. Please forgive me if I've trespassed.
I'm having trouble with a delete query. My intent is to delete records in
two tables with a one to many relationship. The record selected is based on
a form's text box entry. I have first created a select query and the correct
records are shown in both tables when I click on the View icon in the
toolbar. Then, using the toolbar, I change the select query to a delete
query. When I click on the view toolbar, the correct records from both
tables are shown.
The problem is when I click on the "Run" icon or try to open the query from
a macro, Access responds with the following message: "Specify the table
containing the records you want to delete." I've tried a number of different
angles, to no avail. I just don't understand why this message comes up when
the form that is opened and the query both point to the tables that contain
the records I want to delete.