I understand, I just can't see what I'm missing. Curious if a db with that table/form with a hard-coded SQL row source for the combo still throws the error
Same here, i feel like its something stupid simple like a spelling error or something but i've looked over it several times and couldn't see anything.
Tried hard coded rowsource = "SELECT partmatrix.PM_PartNumber AS [Part Number], partmatrix.PM_ToolNumber AS [Tool Number], partmatrix.PM_PartDescription AS Description, partmatrix.PM_PartStatus AS Status
FROM partmatrix
WHERE (((partmatrix.PM_PartNumber)='6150432'))
ORDER BY partmatrix.PM_ToolNumber DESC;"
populates the contents of the listbox just fine as before but still returns Null's when double clicked.
then tried to set the forms recordsource = partmatrix table..... same result.
Then also set the listbox's control source to the part matrix table and still returned null's