Hi all, I'm trying to use a button to open a form, but the trick is I need to the form to show a selected users data in the form when opened. I have the users in a subform within a form. In the form you can select a range of data and I want to be able to have someone be able to pick anything within a row and hit the button to show that users info in the form that pops up any idea on what I can do?
Yeah, is there a way I can do this using a wizard in access 07? or do I have to do it using VB? Also is there a way to use any entry from the selected record say I click anything in that record and hit the button to open the form. Is there a way to make it so it's not any specific entry, or do I have to manually enter each field in to make it so that works.