Passing values between forms

  • Thread starter Thread starter Shiller
  • Start date Start date
S

Shiller

Experts,

I'm trying to pass value from FormA to an unbound Text Box on FormB, I
put the following reference in the Default Value properties of UserID
on FormB:

=[Forms].[FormA].[UserID]

The problem is it only works when FormB is open in Maximize view.

Is there a solution to this problem besides forcing FormB to open in
Maximize view.

Thanks
 
Shiller said:
Experts,

I'm trying to pass value from FormA to an unbound Text Box on FormB, I
put the following reference in the Default Value properties of UserID
on FormB:

=[Forms].[FormA].[UserID]

The problem is it only works when FormB is open in Maximize view.

Is there a solution to this problem besides forcing FormB to open in
Maximize view.
Click to expand...


I can't reproduce this problem (although the form reference should properly
be "=[Forms]![FormA].[UserID]"). What version of Access are you using? I
tested with Access 2003.
 
Experts,
Click to expand...
I'm trying to pass value from FormA to an unbound Text Box on FormB, I
put the following reference in the Default Value properties of UserID
on FormB:
=[Forms].[FormA].[UserID]
Click to expand...

The problem is it only works when FormB is open in Maximize view.
Click to expand...
Is there a solution to this problem besides forcing FormB to open in
Maximize view.
Click to expand...

I can't reproduce this problem (although the form reference should properly
be "=[Forms]![FormA].[UserID]").  What version of Access are you using?  I
tested with Access 2003.
Click to expand...

Thanks Dirk for your help, I changed the reference and I also removed
an old Macro that was opening FormB before FormA. It works great now.

Thank you so much for helping.
 
Back
Top