To go round a dificulty (?)

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

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.

 

[Guest]

O,

The first solution is work fine.
Many thanks more one time.
an