control source in report

[FlyingDragon via AccessMonster.com]

hi all
i have a report called (Serials) which have a textbox called (user_inf)
and i have a form called (frm-UserLogon) which have two textboxes one of them
called (user) and the other called (pass)
in my database the user enter his name and password in the form (frm-
UserLogon) to continue ... if it correct the form closed and the main form
opened
Now i want the textbox called (user_inf) in report (serials) display the user
name in textbox (user) in form (frm-UserLogon) even it change
i use the code =[Forms]![frm-UserLogon]![user] but it gives me (#Name?)
thanks for all

 

[Allen Browne]

You say that frm-UserLogon is *closed* after the user successfully enters
their name? If so, attempting to refer to a text box on the closed form
won't work.

 

[FlyingDragon via AccessMonster.com]

You say that frm-UserLogon is *closed* after the user successfully enters
their name? If so, attempting to refer to a text box on the closed form
won't work.

i have a report called (Serials) which have a textbox called (user_inf)
and i have a form called (frm-UserLogon) which have two textboxes

[quoted text clipped - 5 lines]

user name in textbox (user) in form (frm-UserLogon) even it change
i use the code =[Forms]![frm-UserLogon]![user] but it gives me (#Name?)

so what can i do ?

 

[Allen Browne]

You say that frm-UserLogon is *closed* after the user successfully enters
their name? If so, attempting to refer to a text box on the closed form
won't work.

i have a report called (Serials) which have a textbox called (user_inf)
and i have a form called (frm-UserLogon) which have two textboxes

[quoted text clipped - 5 lines]

user name in textbox (user) in form (frm-UserLogon) even it change
i use the code =[Forms]![frm-UserLogon]![user] but it gives me (#Name?)

so what can i do ?

Try leaving the form open.

 

[Duane Hookom]

In addition to Allen's advice, you could set your form's Visible property to 0.
--
Duane Hookom
Microsoft Access MVP

You say that frm-UserLogon is *closed* after the user successfully enters
their name? If so, attempting to refer to a text box on the closed form
won't work.

i have a report called (Serials) which have a textbox called (user_inf)
and i have a form called (frm-UserLogon) which have two textboxes
[quoted text clipped - 5 lines]
user name in textbox (user) in form (frm-UserLogon) even it change
i use the code =[Forms]![frm-UserLogon]![user] but it gives me (#Name?)

so what can i do ?

Try leaving the form open.

 

[FlyingDragon via AccessMonster.com]

In addition to Allen's advice, you could set your form's Visible property to 0.[quoted text clipped - 9 lines]

Try leaving the form open.

thats it many thanks