How to create an Update Query Form

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

John:

One other thing. Can I create a form that relates to the update query? For
example, if the form had on it:

Table to update ----combo box
Field to update ---- combo box
A field that allows me to enter the expression to update the appropriate
field in selected table
A run button to activate the query that updates the subject field in the
subject table

Any additional comments are most welcomed.
 
While you can use the combo box as a parameter to provide the value to be
used for update purposes, you cannot use parameters to specify the table or
field names. You'll have to dynamically generate the SQL.
 
Back
Top