Union Delete question

[SL]

I have a continuous form bound to a UNION query, that displays information
from 2 different queries. This displays the records in the form fine but I
want the user to have the ability to delete the records individually if
required with a check box. I can't do this with a bound check box because the
recordsource is a UNION query and because its a continuous form I can't do it
with code behind the check box as selecting one record will select all.

Does anyone know if its possible to achieve this using a UNION query?

Thank You

Sonya

 

[KARL DEWEY]

When you go from union query to form you have lost the information as to
which table the information is from.

This I have not tried but is a thought ---
If your union query had a primay key field outputed and an alias that told
which table the data was from ( "firstTable" AS TableID ) and then had these
field in the form (no visible if you want) you could use them in criteria for
you delete queries called by macro called by your command button.

 

[SL]

I changed the check box to a command button and put the delete statement
behind it after adding another query with an alias to the UNION query and it
all works ok.

Thanks for your help.