GotoRecord with a variable

[bibo]

I have a form that displays UserIDs, I want to be able to click on this
userID and it
opens up this paricular USer's record in another form. I've tried using
macros, to OpenForm and then GotoRecord, but the gotoRecord options does not
allow me to specify passing this UserID in the "offset" option. Please help
me, there must be a way to pass a value from one from to another form to open
up a specific record.

Please help

 

[KARL DEWEY]

Have you thought about using the UserID as criteria in the query for second
form?
Like this --
[Forms]![YourFormName that displays UserIDs]![ObjectName that selects
UserIDs]