Find Record From Form

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

Guest

I have a list of clients in a form. Beside each client I have a button.
When the button is clicked it opens a dialog form that I would like to show
information about that client. However, when the dialog form opens, it is
always on the FIRST record from the first form. How can I have the dialog
form open to the record I've clicked on in form #1?
 
docmd.OpenForm "Client_Detail",wherecondition:="Client_ID=" &
me.client_id,windowmode:=acDialog

where me.client_id is a reference to a control or field which contains the
Record ID

- Raoul
 
Back
Top