form object

[Simone]

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

[Wayne Morgan]

You are defining frmEntry as a Form, but you are passing a form's name (a
string value), not a form.

--
Wayne Morgan
Microsoft Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

[Simone]

Thanks before you posted I changed to string and it worked.
My issue now is I need it to be a form object because once runs
through the code I want to pass a value to a text box for that form
object. Using text I can't do frmEntry.controlname
I tried passing but I get the same error before.

Any ideas?
Thanks.

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<mS*******************@newssvr32.news.prodigy .com>...

You are defining frmEntry as a Form, but you are passing a form's name (a
string value), not a form.

--
Wayne Morgan
Microsoft Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

[Wayne Morgan]

Forms!frmEntry!ControlName

--
Wayne Morgan
MS Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Thanks before you posted I changed to string and it worked.
My issue now is I need it to be a form object because once runs
through the code I want to pass a value to a text box for that form
object. Using text I can't do frmEntry.controlname
I tried passing but I get the same error before.

Any ideas?
Thanks.

"Wayne Morgan" <co***************************@hotmail.com> wrote in

message news:<mS*******************@newssvr32.news.prodigy .com>...

You are defining frmEntry as a Form, but you are passing a form's name (a string value), not a form.

--
Wayne Morgan
Microsoft Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

[Wayne Morgan]

ps. The period will work also.

Forms!frmEntry.ControlName

--
Wayne Morgan
MS Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Thanks before you posted I changed to string and it worked.
My issue now is I need it to be a form object because once runs
through the code I want to pass a value to a text box for that form
object. Using text I can't do frmEntry.controlname
I tried passing but I get the same error before.

Any ideas?
Thanks.

"Wayne Morgan" <co***************************@hotmail.com> wrote in

message news:<mS*******************@newssvr32.news.prodigy .com>...

You are defining frmEntry as a Form, but you are passing a form's name (a string value), not a form.

--
Wayne Morgan
Microsoft Access MVP
"Simone" <oi****@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

[smitty mittlebaum]

Simone wrote:

Hello

I am really confused on this.
I have a button that calls a module.

Sub verifyUser(frmEntry As Form)
This module does a few things then it opens a form.

I am passing a variable as form to the module
call verifyUser("frmFollowUp")

If add quotes it says type mismatch if I remove the quotes it says
"Byref argument type mismatch"

I don't know what I am doing wrong.
Please help.

Thanks.

Simone

I may be wrong, but I think that you need to do this BEFORE you do the call:
DIM frmVar as form
set frmVar = frmFollowUp
call verifyUser(frmVar)

(I'm not 100% certain about the syntax for the SET command, you may need
to look into that)

Hope this helps a little - or a lot :)