
February 4th, 2004, 09:52 PM
|
|
Registered User
|
|
Join Date: Oct 2003
Posts: 12
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Macro to find record & go to diff. form
Hi there
I have created a simple database using wizards only. There is a main form (listing our publications) that has a lookup field (design_ID) from another table on it that displays the name of the design studio associated with that publication in a drop-down value list.
I would like to add a command button next to this field that takes the user to the corresponding design studio record on another form that contains all the details for the design studio. From the design studio form I would like to include a button that then takes the user back to the publication record they were originally viewing.
Any suggestions on how to do this (for someone who has obviously only very basic knowledge of Access, nevermind VB!)
Thanks very much.
|