Hi all,
I would appreciate your help with the following issue (presented in somewhat simplified way):
I’ve got two tables: tblTrainees and tblObjectives.
I’m entering data to tblTrainees via frmTrainees. One of the fields in the form is Subject – its Row Source is tblObjectives and the Row Source Type is Table/Query.
tblObjectives has the following fields: ID, Subject, Objective1, Objective2.
I’ve got a very simple query that polls the Subject from tblTrainees and Objective1 and Objective2 from tblObjectives. The problem is that the query doesn’t present any values for Objective1/2 although they have values in tblObjectives.
What is more puzzling is that the query works fine for "historical" data in tblTrainees (by "historical" I mean data that I imported into the database from an Excel file) – the problem occurs ONLY for data which I recently entered to the database via the form.
Any idea?
Thank you in advance for your support
I would appreciate your help with the following issue (presented in somewhat simplified way):
I’ve got two tables: tblTrainees and tblObjectives.
I’m entering data to tblTrainees via frmTrainees. One of the fields in the form is Subject – its Row Source is tblObjectives and the Row Source Type is Table/Query.
tblObjectives has the following fields: ID, Subject, Objective1, Objective2.
I’ve got a very simple query that polls the Subject from tblTrainees and Objective1 and Objective2 from tblObjectives. The problem is that the query doesn’t present any values for Objective1/2 although they have values in tblObjectives.
What is more puzzling is that the query works fine for "historical" data in tblTrainees (by "historical" I mean data that I imported into the database from an Excel file) – the problem occurs ONLY for data which I recently entered to the database via the form.
Any idea?
Thank you in advance for your support