How to create an Update Query Form

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

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