union query to form. edit table values???

[rmulder]

alright i got two queries i unioned through sql. they query separate tables that are similar enough. my results are shown together but I can't edit the table data from the query even if i convert to form and add text boxes etc. Is this just a byproduct of union queries?

 

[SOS]

Union Querys are not updateable.

 

[rmulder]

bummer. im still pretty new. would there be another easy way to display two queries/form from those queries on one page or tabbed possibly. i got two queries that have a strong relationship that it'd be nice to see them in the same window...

 

[SOS]

Subforms would be the way to go.

 

[rmulder]

thanks SOS!

 

[Simon_MT]

When you build a Union Query keep the (two) parts as each part needs to the same and use these either in SubForms or separate Forms.

Simon