quick user log in question

[thierry14]

Hi,
Could anyone tell me whats wrong with this piece of code, the error says access cant find the form i'm looking for..'frmuser'

txtwelcome.Text = Form!frmuser.cboUsers.Text

basically its a text box that should show the persons name who logged in to the system on the login page. I've put this code in the form load event of the main page (after log in)

thanks alot

 

[rat_b76]

Hi,

Firstly, the correct syntax is 'Forms' not 'Form', additionally you will need to open the form first before trying to gather information from the specific form.

Basically before you request the information, open the form in its hidden state, once you have got the value in the required text box etc. close the form.

Hope this helps.

Cheers.

 

[thierry14]

thanks for the reply, can you tell me how to open a form in hidden state? i've been looking but with no joy..thanks!

 

[ghudson]

thanks for the reply, can you tell me how to open a form in hidden state? i've been looking but with no joy..thanks!

acHidden is one of the WindowMode options used in the OpenForm method.

OpenForm Method

Searching the forum is a great way to discover and learn the answers to your Access programming questions.