|
View Full Version : label with text and record combined jasn_78 08-31-2008, 04:49 PM 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 08-31-2008, 05:03 PM You didn't mention the error. Just to be sure, is the field in question bound or unbound? jasn_78 08-31-2008, 05:09 PM georgedwilkinson I get a circular reference error and how do i check wether the label is bound or unbound? georgedwilkinson 08-31-2008, 05:28 PM 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 (http://www.access-programmers.co.uk/forums/showthread.php?t=140587) jasn_78 08-31-2008, 05:34 PM George, thanks all working must have had a typo in there somewhere georgedwilkinson 08-31-2008, 05:48 PM Okey doke. Glad you got it working. |