Formula in text box

[szag via AccessMonster.com]

I am having a problem with the following formula in a textbox:

=[Forms]![F_Master_Buyer]![F_AFE].[Form]![cbutJob] & " - " & [Forms]!
[F_Master_Buyer]![F_AFE]![F_AFE_subform].[Form]![Vendor_AFE]

Its basically just a label in a subform. The problem is that it will return
the desired results one time, then I will go into the dbase a different time
and it will display #error. I can't figure out the random nature of this!

Thanks for any help.

 

[Marshall Barton]

I am having a problem with the following formula in a textbox:

=[Forms]![F_Master_Buyer]![F_AFE].[Form]![cbutJob] & " - " & [Forms]!
[F_Master_Buyer]![F_AFE]![F_AFE_subform].[Form]![Vendor_AFE]

Its basically just a label in a subform. The problem is that it will return
the desired results one time, then I will go into the dbase a different time
and it will display #error. I can't figure out the random nature of this!

Hard to tell without more information, but with the just
above, all I can guess is if either one of the two subform's
does not have any records, #Error would be expected.

 

[Mike Painter]

I am having a problem with the following formula in a textbox:

=[Forms]![F_Master_Buyer]![F_AFE].[Form]![cbutJob] & " - " & [Forms]!
[F_Master_Buyer]![F_AFE]![F_AFE_subform].[Form]![Vendor_AFE]

Its basically just a label in a subform. The problem is that it will
return
the desired results one time, then I will go into the dbase a different
time
and it will display #error. I can't figure out the random nature of this!

Thanks for any help.

You have [F_AFE] in one case and [F_AFE_subform] in the other.

I think the questions should be why does it work rather than the opposite!

 

[szag via AccessMonster.com]

Mike-

Well there are two parts to the formula:

1: [Forms]![F_Master_Buyer]![F_AFE].[Form]![cbutJob]

and

2:[Forms]![F_Master_Buyer]![F_AFE]![F_AFE_subform].[Form]![Vendor_AFE]

In #1 I am returning the "cbutJob" off the F_AFE form and I am combining that
with #2 where I am getting the "Vendor_AFE" value off of the F_AFE_Subform
(which is a subform of F_AFE).

Is there something I am doing wrong here? this is how I was instructed to get
these values.

thanks!

I am having a problem with the following formula in a textbox:

[quoted text clipped - 8 lines]

Thanks for any help.

You have [F_AFE] in one case and [F_AFE_subform] in the other.

I think the questions should be why does it work rather than the opposite!