label with text and record combined

[jasn_78]

Ok now I am sure this is pretty easy as I have done it with records off forms but for some reason when i try and combine some custom text with a record from a query I get an error

="ABN" & [STORE_ABN]

that is the line i am typing in the label but with no luck
any help would be appreciated.

 

[georgedwilkinson]

You didn't mention the error.

Just to be sure, is the field in question bound or unbound?

 

[jasn_78]

georgedwilkinson

I get a circular reference error and how do i check wether the label is bound or unbound?

 

[georgedwilkinson]

Sounds like the label is referencing itself (that is to say, it may be named STORE_ABN).

You check whether bound/unbound in on the data sheet in properties. If it has a control source, it is bound.

Additionally, you might want to make sure that you don't have a control with the exact same name as the column in the table it is bound to. This is the default from the wizard and causes all kinds of problems. You should rename all text boxes to "txt"WhateverItWasNamedBefore and all combo-boxes to "cbo"WhateverItWasNamedBefore.

I have a little extra time, if you can't fix it and want to upload your db: How To Upload A Database To The Forum

 

[jasn_78]

George, thanks all working must have had a typo in there somewhere

 

[georgedwilkinson]

Okey doke. Glad you got it working.