Does recordsource accept a query with union statement?

  • Thread starter Thread starter Yumex85
  • Start date Start date
Y

Yumex85

Im trying to load a query making using 4x unions to put 4 select
queries together putting it at a form recordsource. Does that work?
Coz im getting the error the record source specified on this form or
report does not exist.
 
A union query can be used as the RecordSource of a form or report, yes. It
will be read only, but it is not the cause of the error you are seeing. Try
double-checking the code or property where you are assigning the
recordsource ... perhaps you have a typo there. If you can't find it, try
copying and pasting the code or property setting here, and someone might be
able to see what the problem is.
 
Im trying to load a query making using 4x unions to put 4 select
queries together putting it at a form recordsource. Does that work?
Coz im getting the error the record source specified on this form or
report does not exist.
Click to expand...

I have no problems making a UNION-query recordsource of a form!
 
oh i found out why ,guys. I had to put all my tables and select fields
in query between [] like
select
.[field] from
........ weird tho.
Then it worked! Thank you for ur help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Created A union Query of two tables, Would like to count records s 9
union queries - with tables containing fields with attachments 2
Union Query Problem 6
Union Queries 5
Union does not show all records 5
UNION Query Parameters 1
Form's new SQL recordsource returns nothing 5
Trouble with a union Query 2

Back
Top