To go round a dificulty (?)

A

an

Hello!

I need to make a form based in two queries.
But isn't possible to change data in this form.
How is possible to go round this dificulty, please?
Thanks in advance.
an
 
O

Ofer

I can advice you on two options
If you can update each query individualy, then create a Form, and in the
form create two sub forms, each based on a query.

The second way, to make all the fields unbound, on the load event of the
form, assign values to this fields using vba
open a recordset based on the two queries and then assign the values.
On the unload event, prompt the user with a message if he/she want to save
the data, if yes run an update query to update all the values from the fields
to the tables.
 
A

an

Well...
Thanks for your help, but for me....
an


Ofer said:
I can advice you on two options
If you can update each query individualy, then create a Form, and in the
form create two sub forms, each based on a query.

The second way, to make all the fields unbound, on the load event of the
form, assign values to this fields using vba
open a recordset based on the two queries and then assign the values.
On the unload event, prompt the user with a message if he/she want to save
the data, if yes run an update query to update all the values from the fields
to the tables.
Click to expand...
 
Top