highlighting a record in a tabular form? 1

[brightstar]

hey all,
im looking at records on a tabular form... then i click abutton to open up a form with more information on it. the previous form is closed when the new form is opened. the linking field is available on both forms.. but how do i use it to go back to the record i just came from, in other words how do i make it the focused record when i return to the first form?

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world

 

[faeryfyrre]

There are a few ways you can do this.

One way would be to pass your RecordID to the opening form via OpenArgs and having code (similar to the code i have appended at end of my post) in the Form_Load event of the opening form.


Private Sub Form_Load()

dim rs as dao.recordset

if not nz(me.openargs) = "" then
Set rs = Me.RecordsetClone
rs.FindFirst "[RecordID] = " & Me.openargs
if not rs.nomatch then
Me.Bookmark = rs.Bookmark
end if
end if

end sub


Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[brightstar]

thats marvellous thanks.

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world