How to create an Update Query Form

[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.

 

[Douglas J. Steele]

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.

 

[Grace]

Thanks for assistance,