form from query

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a parameter (surname) query from which I would like to create a form
for (further) data entry purposes. I have created a new table for that data,
but the form wizard won't allow combining a query and a table, what do I need
to do?
Thanks
Karen
 
You need a Union Query. There is not a wizard. You would create a query in
design view, dont add any tables, then right click in the designer, and
select SQL specific. There you will see Union Query. If both your table and
your query have the exact same number of colums, then you could write a
simple Union Query like this.

Select * From YourQueryName
Union All
Select * From YourTableName

If the number of columns differ, your query would look something like this

Select [UserName], [Address], [City]
From YourQueryName
Union All
Select [User], [ADDR], [City]
From YourTableName

Here is a good reference to look at when building your Union Query
http://office.microsoft.com/en-us/access/HA102061091033.aspx
Hope this helps.
 
I have a parameter (surname) query from which I would like to create a form
for (further) data entry purposes. I have created a new table for that data,
but the form wizard won't allow combining a query and a table, what do I need
to do?
Thanks
Karen
Click to expand...

You would need to create a new query, using the existing query and the
table, and use this new query as the record source for the form.
Note: Some queries are not updateable, so you may not be able to edit
existing or add additional records.

In Access help search
Query + Troubleshoot queries + Select Query + I can't update data from
a query + Data can't be updated
 
Back
Top