Greetings,

I have a form. This form has a combo box that looks up records in a table. When the form opens up and I click on the combo box, the records display in the drop-down list just fine. HOWEVER, when I select one of the records I get an error message that my application 'CAN'T FIND THE OBJECT...'. It's also telling me that I either misspelled it OR that I am using a linked table?

Any suggestions would be great. I will provide any further info. if necessary.

thanks

Paul

__________________
Paul

Paul,

What is the record source for the combobox? (Go to the Data Tab on Properties)?

Thanks. This is what is in the recordsource line.

"SELECT [T_SetupSheetCombinationsDetail].ComboCustPartNum, [T_SetupSheetCombinationsDetail].ComboLength, [T_SetupSheetCombinationsDetail].ComboColor, [T_SetupSheetHeader].CustPartDescription, tblArCust.CustName, [T_SetupSheetCombinationsDetail].QuoteID FROM [tblArCust] INNER JOIN ([T_SetupSheetCombinationsDetail] INNER JOIN [T_SetupSheetHeader] ON [T_SetupSheetCombinationsDetail].QuoteID = [T_SetupSheetHeader].QuoteID) ON [tblArCust].CustId = [T_SetupSheetHeader].CustID WHERE ((([T_SetupSheetCombinationsDetail].ComboCustPartNum) Is Not Null) AND (([tblArCust].CustId)= 'AME04')) ORDER BY [T_SetupSheetCombinationsDetail].ComboCustPartNum"


thanks and hope it helps... f.y.i. when I ckick on the arrow button of the combo box, it does return rows for me.

Paul

Yeh, SOMETHING is probably misspelled or missing in here then. It can't find it so your combo box then WILL be empty.

How did you make your combo box?

What are T_SetupSheetCombinationsDetail, T_SetupSheetHeader? (are they tables?)
Did you CHANGE ANYTHING (either a name or did you remove anything) from tblArCust or T_SetupSheetCombinationsDetail or T_SetupSheetHeader after you created the combo?

Yes. The these ARE the tables. This is in fact the code I use in the record source line in order to bring back info. to the drop-down list for the combo box. Just to clarify, the drop-down list of the combo box IS getting populated. It's when I select a row that it barks.

thanks...

Paul

Sorry Paul, I missread what you said.

Taking a quick look at your SQL it looks like the parenthesis are all there. Can you confirm item by item that each field is spelled correctly and exists in its given table?
Is there anything in the click event of the combobox?