#Error

[Pookiemeister]

On my form I have 5 textboxes. Each will be pulling its value from a Query based on the value of the first textbox. The error in the subject displays in the ItemDescriptiontxtbx when the form loads. Textbox names and their order below:
Textbox Names
1. Itemtxtbx
2. ItemDescriptiontxtbx
3. ManufactureNametxtbx
4. ManufacturerPartsNotxtbx
5.UOMtxtbx

QUERY FIELD NAMES (These were imported from an Excel spreadsheet)
1. Item
2. ItemDescription
3. ManufacturersName
4. ManufacturersPartNo
5. UOM

I have the following DLookup code inside the "Control Source"

=DLookUp("ItemDescription","InventoryDetailsQuery","Item = " & [Itemtxtbx])

Would it possible that the issue maybe from something that is set in the property sheet for ItemDescriptiontxtbx?

I hope I provided enough information. Thank you

 

[Micron]

What is the data type of the field? If Item data type is text then it must be delimited. In that case, try:

"Item = '" & [Itemtxtbx] & "'")

Trying to remember if DLookup allows criteria to be the name of a control. You may need to use Me.Itemtxbx

 

[Anthony47]

That string (#Error) seems to be set by a macro, so without the full code that handle the form it would be difficult to make any guess...