J
Jeannie
My setup:
tblPeople, key PeopleID (autonumber), additional contact info fields
tblSpeakers, composite key PeopleID and SpeakerID(text), additional fields
Main form from tblPeople, subform tblSpeakers. When I first open the form,
it works fine until I get to the SpeakerID field on the subform - I need to
enter text to assign a SpeakerID, but receive the error message. I click ok,
and am allowed to enter text. I checked and it is stored correctly in the
tables. Subsequent entries are fine - I only receive the error on the first
entry. What's wrong? I will need to use this for queries and reports and am
worried it will cause problems.
Thanks!
tblPeople, key PeopleID (autonumber), additional contact info fields
tblSpeakers, composite key PeopleID and SpeakerID(text), additional fields
Main form from tblPeople, subform tblSpeakers. When I first open the form,
it works fine until I get to the SpeakerID field on the subform - I need to
enter text to assign a SpeakerID, but receive the error message. I click ok,
and am allowed to enter text. I checked and it is stored correctly in the
tables. Subsequent entries are fine - I only receive the error on the first
entry. What's wrong? I will need to use this for queries and reports and am
worried it will cause problems.
Thanks!