Forms and Update Querys

  • Thread starter Thread starter Simon R
  • Start date Start date
S

Simon R

Is there anyway to create a form that is the front end
for an update query, so that the infomation you want to
update can be added into some boxes, you then click a
button and the relevant records then have the numbers
added and updated?

Im currently having to open the update query, enter the
numbers, run it, then close it, but i would like a form
to do this instead.

Any help would be appreciated, or any links to
instructions to do it would be really helpful.
 
In general, the update query's "Update To:" box can contain a reference to a
control on an open form:
[Forms]![Formname]![ControlName]
 
Back
Top