using a string to pull up a record on a form

[RyanB]

Sorry if this has been asked before but I have searched and couldn't find an answer

I have a string that is set on startup (username) and have another form(hidden) that loads on startup this form contains information on what forms and options the user can access. Just having a little trouble using the string to pull the correct record, the information in the string would be from the primary key field on the table.

Thanks

Ryan

 

[Steff_DK]

Where does the problem lie?

Pulling data form the hidden form, or looking up the record once you have retrieved data from the hidden form?

(did you remember to set focus back to the right form after gettign data from the hidden one )

 

[RyanB]

Hi,

I can get the data when its in the form.

The problem is getting the form to load the right record when its opened. I think this is probably a really basic question that I should know. So i'm gonna be kicking myself but for the life of me I can't work out how to do it.

Basically i'm asking how to use a value stored in a string to load a record on a form.

Thanks

Ryan