Select a record in datalist and opend form based on that record

  • Thread starter Thread starter Eric Blitzer
  • Start date Start date
E

Eric Blitzer

I know how to open a form based on a criteria from a single
form. How do I open a form based on the selected record in
a data list form?

Thanks

Eric Blitzer
 
If by data list form you mean continuous form, add Record Selector to the
form. When you click on the record selector for a particular line item you
can have a command button that runs a macro to open the new form based on
that selection. In the 'Where' part of the Open Form' macro enter (for
example): [ClientID]=Forms![NameofOpenForm]![ClientID]. The new form then
opens to that specific record.

Con Giacomini
 
Back
Top