G
GasMan
Hi,
I have a form Attendees that keeps track of people attending a
seminar. The form is called from a Practice_admin form that has a
practice_id on it, and the button does the normal stlinkcriteria. I
used the wizard. The query for the form attendees links the 2 table by
pratice_id. The attendee form allows for additions, deletes etc.
The problem I have is that if no attendee exists for a practice, then
I want to add 1, yet the form remains blank. To get around this I have
been adding via datasheet view, but need to cut and paste the
pratice_id from the pratice_admin form to the attendeee table. When a
record is in the attendee table for the parent the form will display
correctly and even allow me to edit the data.
I'm new to access, but cannot see why it will not work properly.
The above is in Access 2000. I tried some experimenting in Access 97
on my home computer with teh book collection database whereby I tried
the same links with Topic in the book table and topics table.
I added a topic that I knew did not exist, but the form STILL allowed
me to add a book for that topic.
What am I missing?? and what should I be looking for. No code is
setting the Allow properties of the attendee form to false.
TIA
Please remove obvious from email address if emailing.
I have a form Attendees that keeps track of people attending a
seminar. The form is called from a Practice_admin form that has a
practice_id on it, and the button does the normal stlinkcriteria. I
used the wizard. The query for the form attendees links the 2 table by
pratice_id. The attendee form allows for additions, deletes etc.
The problem I have is that if no attendee exists for a practice, then
I want to add 1, yet the form remains blank. To get around this I have
been adding via datasheet view, but need to cut and paste the
pratice_id from the pratice_admin form to the attendeee table. When a
record is in the attendee table for the parent the form will display
correctly and even allow me to edit the data.
I'm new to access, but cannot see why it will not work properly.
The above is in Access 2000. I tried some experimenting in Access 97
on my home computer with teh book collection database whereby I tried
the same links with Topic in the book table and topics table.
I added a topic that I knew did not exist, but the form STILL allowed
me to add a book for that topic.
What am I missing?? and what should I be looking for. No code is
setting the Allow properties of the attendee form to false.
TIA
Please remove obvious from email address if emailing.