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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenArgs 2
combobox blank 1
Order by in rowsource 1
Applying a Filter on a Subform 4
One to many relationship 4
Suggestion for Append 3
Make Payment and Deduct from Bill 2
prevend dupes if 3

Back
Top