Command Button

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
 
A

Allen Browne

Try this in the Click event procedure of your button:

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