Detailed form

  • Thread starter Thread starter dagelli
  • Start date Start date
D

dagelli

Hi Everyone

i am a little stumped on how to get a form to pop up after a double click
evenyt on a record showing in a subform,

i need to show more detail than i can fit in the subform and want allow a
user to double click the name in the subform to bring up the detailed form.

i have managed to get the form to work but i have lost my way a bit to get
it to show the appropriate record

any tips would be great

reagrds greg
 
Hi Greg,

The easiest way is to use the WhereCondition parameter of docmd.openform.
For example, the following will open the form "CustDetails" and filter it
according to the "Custid" on the current record in the calling form.

docmd.OpenForm "CustDetails",,,"Custid=" & me.custid
 
Back
Top