Edit Record from a Query result

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

Guest

I am accepting parameters from the user. then run a query to display all the
records.

Once i display all the record, i would like the user to click on the
particular record that he/she is interested in for edition or deletion.

how can i do this??

thanks
 
I am accepting parameters from the user. then run a query to display all the
records.

Once i display all the record, i would like the user to click on the
particular record that he/she is interested in for edition or deletion.

how can i do this??
Click to expand...

You can't, *in a Query* - query datasheets have no usable events.

What you can do instead is to base a continuous Form on the query, and -
rather than running the query - just open the form. You can put a Go! command
button on the form to open a record edit form (or, for that matter, just let
the user edit data directly in the continuous form).

John W. Vinson [MVP]
 
Back
Top