default value question

[Slez via AccessMonster.com]

I'd like the default value of the control (Markup) in one form
(frmBidLineItemSubform) to be the value that exists in a control
(txtProjectMultiplier) of another form (frmBid). I've tried entering the
following expressions in the Default Value Property setting of the control
Markup...

Forms!frmBid!txtProjectMultiplier
=Forms!frmBid!txtProjectMultiplier
=Forms!frmBid.[txtProjectMultiplier]
=(Forms!frmBid.[txtProjectMultiplier])

...among other combinations. But all that ever shows up as a value in the
control is "#Name?".
What am I doing wrong??
Thanks
Slez

 

[luanhoxung]

How many values txtProjectMultiplier stored ?
I guess it stored more than 2 different values. So if u want set
Markup value by txtProjectMultiplier value. Access will dont know
choosing which values.
Give us more details what u want to do ?

Luan

 

[Guest]

Slez,

Forms!frmBid!txtProjectMultiplier
or
Forms![frmBid]![txtProjectMultiplier]

should work, but do you have the other form open? And, how will you ensure
the form is open to the record that has the value of interest?

I don't know the relationship between the underlying tables of the two
forms, but if you're trying to get a specific value from a table based on
specific criteria, the DLookup function might serve your need better.

Sprinks

 

[Slez via AccessMonster.com]

After some thinking, I realized that because frmBid existed as a subform, I
needed to reference the mainform first.
Thanks for the replies!

Slez,

Forms!frmBid!txtProjectMultiplier
or
Forms![frmBid]![txtProjectMultiplier]

should work, but do you have the other form open? And, how will you ensure
the form is open to the record that has the value of interest?

I don't know the relationship between the underlying tables of the two
forms, but if you're trying to get a specific value from a table based on
specific criteria, the DLookup function might serve your need better.

Sprinks

I'd like the default value of the control (Markup) in one form
(frmBidLineItemSubform) to be the value that exists in a control

[quoted text clipped - 12 lines]

Thanks
Slez