Ok, here it is. Thanks again for your patience. It's been a humbling experience asking for help. I haven't been level 0 in ANYTHING regarding computers in a long time
sample.zip
Ok, here it is. Thanks again for your patience. It's been a humbling experience asking for help. I haven't been level 0 in ANYTHING regarding computers in a long time
sample.zip
You were close. In the query, you referenced the name of the label for the combo box ([order combo_Label]) not the combo box itself (they are distinct objects each with their own names). The name of the combo box is combo0. So I changed the query to the following
SELECT Adjustments.[Order #]
FROM Adjustments
WHERE (((Adjustments.[Order #])=[forms]![Order combo]![Combo0]));
The revised database is attached.
BTW, it is best not to have spaces or special characters (#, !, (,) etc.) in your table or field names.