Subquery Data Not Writing to Table

[jketcher]

Help please! This may be the beginning of a string of questions. I am developing a new tab in my database that uses a field 'Client' that is entered on the first tab and originates from a 'Client' table. For this 'Client' a list of students and identifying information needs to be entered into a separate table called 'Students'. I created a data entry subform in datasheet format. Since the user selects the 'client' from the first tab, I am populating it in the related 'client' field in the subform data entry using
the Client form entry Forms!Formname!Client. It visually displays, but when the rest of the data is physically entered for that student, the only data that is written to the table is the student identifying data -- not the 'Client'. Client is not the key since a 'Client' can have multiple students. Why is Access not acknowledging the visual entry in the client field on the student form when the record is written to the table and what can I do to fix this? Thanks so much...

Jkether

 

[Fear Naught]

Is the subform linked to the main client form? If not then it can't put the relevant clientId (assuming you are using some form of unigue identifyer for the clients).

Do you have relationships setup in the database so that Access knows that clients and students are related (one to many relationship).