Passing values between forms

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
 
D

Dirk Goldgar

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.


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.
 
S

Shiller

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.

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top