Record Selector

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have a form with a sub form. On this sub form, I have listed the
equipment based on the Main form client selection list box. What I would
like to do is open a new form based on the record selector on the sub form
and have it filter for the equipment that is clicked only. Is this possible?
 
Yes, just put it in the Onclick event for the item they
have selected. ie, docmd.openform "my new form"
You can also have it filtered for the value that they
clicked on so that when the new form opens you only see
the matching values.
Max
 
Thanks Max, however, I have to add my code to the ONCLICK event of the
field. Is there a way to add the code to the record select?
 
Back
Top