To go round a dificulty (?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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...
 
Back
Top