I am trying to put a button on my switchboard to lookup a reocrd on a form by employee name and date so it can be opened and edited but only the record chosen. is this even possible?
Advanced Beginner
Windows 7 64bit 
Access 2007
I am trying to put a button on my switchboard to lookup a reocrd on a form by employee name and date so it can be opened and edited but only the record chosen. is this even possible?
Novice
Windows 7 32bit Access 2010 32bit
One way of doing this is by creating a SELECT query using parameters. The user would enter the name and the query would open the form with that record. A spilt view (Pretty layout up-top and datasheet down the bottom) would be best so that if the query returns more than one result the user can easily switch between the records. Does this sound like what you are trying to achieve?
VBA: Find Record from in table from form
Edit record in form with original entry shown
Opening Form to a record with same ID value in field. (FIND on open)
Posting Permissions
Reply With Quote