Combobox in Navigation Form

[tazzzz]

This is a sample of my database.

[June7]

You are not using dynamic parameterized query as subform RecordSource. You are simply referencing the tables.

Because of the combobox properties, value of combobox is ID. However, the query has parameter under the JOBNUMBER field. Either change the combobox properties or put the query parameter under the ID field.

[tazzzz]

Thanks for looking into it.