GotoRecord with a variable

B

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
 
K

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GoToRecord function doesn't work on 2nd click 3
Openargs and gotorecord 5
Button on Form not working 2
How to .GoToRecord on another form 2
GoToRecord command 3
GoToRecord 3
Access Access 2003 GoToRecord Problems 0
Gotorecord Where Equal 2

Top