Multi-page Forms

[MitchJP]

Hi all,

I had a form which consisted of a single page (one 'tab') and now I've added multiple pages. I now get an error for the following code:

intCurrentLevel = Me![Current Level]


This line of code assigns the value of 'Current Level' to the variable intCurrentLevel.

I think the problem is with the use if "Me!", and now that I have muktiple pages, it doesn't know what Me! is... Am I correct? If so, What is the proper syntax?


I've tried this syntax, but it didn't work either:
intCurrentLevel = FormName.PageName.[Current Level]

 

[lupins46]

Tabs do not affect syntax in any way.
So intCurrentLevel = Me![Current Level] is correct whether you have a tab control or not.

What error message are you getting?

 

[MitchJP]

Message:

"Database can't find the field 'Current Level' referred to in your expression."

It's worked before, but is now bombing once I've added the 2nd page (with other fields, none of them are Current Level)

 

[MitchJP]

Nevermind, I've figured it out. Somehow the data source for the form was erased... So I've resolved it.

Thanks for the help!