Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Bookmarks to edit same record from 2 differen forms

Status
Not open for further replies.

BitCounter

Programmer
Feb 18, 2000
28
US
Everyone!<br>
<br>
Thanks for reading my question! I would like to be able to edit the same record from 2 forms...could this best be accomplished by setting a bookmark for current record in one form, then opening the second form and (with ADODC control hidden) set current record to bookmark? <br>
<br>
OR...since my 2nd form has only about 4 fields, should I instead save this data to variables and write it to the record once the user returns to the first form?<br>
<br>
Any ideas would be greatly appreciated -- code snippets especially appreciated.
 
I found the answer to my own problem. I was trying to use bookmarks when there was an easier way. My solution involved setting up a variable in the BAS module and sending to it the value of <br>
<br>
datPrimaryRS.Recordset.AbsolutePosition <br>
(i.e., the record number).<br>
<br>
Then in my second form, I simply reset the AbsolutePosition to the value of the variable -- it works like a charm and is relatively simple to implement!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top