Record Selector

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?
 
M

Max Sherman

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
 
J

Jacob

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?
 

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

Top