DblClick function to display table info.

[chrisrigoni]

I realize that this is a beginner's question, but I was wondering if anyone had any suggestions. I have a continuous list on a form and I want to be able to double click on a name and pull up the profile's accesses. The primary key would be the employee code and since it is a continuous list, I want to make sure that it will pull the information for a specific profile instead of the generic for the continuous list. It would be referencing the employee code from the profile on the list and pulling accesses from another table using the employee code. Thank you all for your help!

 

[pbaldy]

You can create a second form based on the other table and use this technique to restrict it when opened:

http://www.baldyweb.com/wherecondition.htm

 

[chrisrigoni]

Thank you so much! I actually ended up making a new form with a query attached to it that pulled the information and restricted the query with the employee code. Then opened the form on double click. It worked well. Thank you again.