 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / September 2005GoTo Current Record
Hi, I have two forms. The main form is in datasheet view. I have a command button on the main form that uses a macro to open the second form. I would like the second form to be open to the record in the main form that had the focus when the button was clicked. I need that to be the only record to come up on the second form. I tried to use the GoTo Record argument, but there is no goto current record. Is there a easy way to do this? use a WHERE clause in the macro's OpenForm action to filter the RecordSource of the second form to show only the record where the primary key value matches the primary key value in the main form. something like [SecondFormPrimaryKeyFieldName] = [MainFormPrimaryKeyFieldName] substitute the correct field names, of course. see the OpenForm Action topic in Access Help for details. hth > Hi, > I have two forms. The main form is in datasheet view. I have a command button [quoted text clipped - 3 lines] > second form. I tried to use the GoTo Record argument, but there is no goto > current record. Is there a easy way to do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.