I think this should be easy - I am calling a form and passing the ID on which the form should filter - but it doesn't work.
This is the calling line:
DoCmd.OpenForm "Vendor_EvalNotes", , "[Expense_ID]=" & Forms("Project")("sfPartsLines").Form.Expense_ID
[note: when I query the value of Expense_ID in debugger, it DOES show the right value]
and this is the record source of the called form:
SELECT Project_Lines_Expenses.Expense_ID, Project_Lines_Expenses.Eval_Quality, Project_Lines_Expenses.Eval_Timing, Project_Lines_Expenses.Eval_Notes, Project_Lines_Expenses.Eval_Notes_Followup FROM Project_Lines_Expenses;
Any ideas why it doesn't show the right record?