Command Button

  • Thread starter Thread starter Oli
  • Start date Start date
O

Oli

Hi

I have a command button and when it is clicked I want it to launch a
separate form but only show results with a ContactID the same as the
ContactID of the current record. Also in datasheet view.

Basic issue, but how?

TIA
Oli
 
Try this in the Click event procedure of your button:

DoCmd.OpenForm "NameOfYourOtherFormHere", acFormDS, , "ContactID = " &
Me.ContactID
 
Back
Top