Continuous Form

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

Guest

Hi,

I have a continuous form based on a query to filter the records into a list
of relevant doctors.
Now I would like that for every record in that form 3 fields are updated on
a simple click of a button. How to do it, cause I currently can only get the
current record to be changed, and I don't want the users to have to click a
button for each record in the continuous form.
 
Ben said:
Hi,

I have a continuous form based on a query to filter the records into
a list of relevant doctors.
Now I would like that for every record in that form 3 fields are
updated on a simple click of a button. How to do it, cause I
currently can only get the current record to be changed, and I don't
want the users to have to click a button for each record in the
continuous form.
Click to expand...

Just run an update query using the same criteria as in your current query.
Automated updates are are rarely done in forms which are intended as a human
interface. Automatic stuff has no need for the form since it can interact
with the data directly.
 
Perhaps I need to clarify.
This list is used to mailmerge and I would like the fields action, actionBy
and actionforproject to update as soon as the merge is being run. In this
way, it will be seen that the record has been contacted by fax, by user and
for that specific project...

How do you run an update query onClick ?
Thanks,
Ben
 
Ben said:
Perhaps I need to clarify.
This list is used to mailmerge and I would like the fields action,
actionBy and actionforproject to update as soon as the merge is being
run. In this way, it will be seen that the record has been contacted
by fax, by user and for that specific project...

How do you run an update query onClick ?
Click to expand...

CurrentDB.Execute "SQL Statement or QueryName", dbFailOnError
 
Back
Top