D
Dennis
I have been trying to make a form with a subform for the
purpose of scheduling appointments. What I would like to
do is have one record, which includes the clinic and the
date I wish to schedule that clinic and a subform which
shows those records that are scheduled at the different
appointment times for the above date and clinic only.
If I change the record in the top of the form, or add
another record, I want the subform to change to all the
records/appointments for that clinic on the changed date
or in the case of adding a date, show blank and enable the
user to enter the new appointments for that date.
What I get now is all records for all clinics and dates I
entered in the clinics table and in the subform all
records for appointments scheduled for all clinics in the
appointments table.
In some of my attempts, I can't enter new information in
the form as I get a message of "This recordset is not
updateable".
Help!
Thanks,
Dennis
purpose of scheduling appointments. What I would like to
do is have one record, which includes the clinic and the
date I wish to schedule that clinic and a subform which
shows those records that are scheduled at the different
appointment times for the above date and clinic only.
If I change the record in the top of the form, or add
another record, I want the subform to change to all the
records/appointments for that clinic on the changed date
or in the case of adding a date, show blank and enable the
user to enter the new appointments for that date.
What I get now is all records for all clinics and dates I
entered in the clinics table and in the subform all
records for appointments scheduled for all clinics in the
appointments table.
In some of my attempts, I can't enter new information in
the form as I get a message of "This recordset is not
updateable".
Help!
Thanks,
Dennis