Dim Function (1 Viewer)

[MAAS8000]

hello,
I have a login form
i want to use the dim function to put the userlogin in the dash board form
i made

Dim getuser As Integer
getuser = [UserLogin.Value]
DoCmd.OpenForm "DashBoard"
Forms![DashBoard]!text5 = getuser

i think there is a problem in the syntax of [UserLogin.Value]
thank you

 

[NauticalGent]

I assume this bit of code is on an event associated with your login form. That being the case, try:

Dim getuser As Integer
getuser =[COLOR="Red"] Me.[/COLOR]UserLogin.Value
DoCmd.OpenForm "DashBoard"
Forms![DashBoard]!text5 = getuser

Remove the brackets as well.

Also, the Value you have assigned to getuser will get lost once you open the form Dashboard. Best to pass the value as an OpenArg.

See Pbaldy's site for an example:
http://www.baldyweb.com/OpenArgs.htm

 

[jdraw]

Maas8000,

Further to NG's advice, is the userLogin really an Integer, not text??