S
Steve
Hello and thanks for the help.
I have a two tables, tblTurnover<Key,Dept,Name> and
TblComments <key,comment>. There is a relationship
between the two on a surrogate key. I decided to go with
a separate table for comments to save space since more
often than not there will be no comments.
I have a main form with a combo box from which you can
select a department option, the subform then reflects the
Name and comment (there is more info obviously) - This
works great. I also want an individual to view records
by name and have made a form from which you can select a
name from a combo box and a subform which shows dept and
comments. This one gives me an error when I try to enter
new information "The property is read only and can't be
set". I press "OK" and the dept remains (drop down box)
and I can continue unhindered from that point on.
I've tried everything except the solution.
Thanks again.
I have a two tables, tblTurnover<Key,Dept,Name> and
TblComments <key,comment>. There is a relationship
between the two on a surrogate key. I decided to go with
a separate table for comments to save space since more
often than not there will be no comments.
I have a main form with a combo box from which you can
select a department option, the subform then reflects the
Name and comment (there is more info obviously) - This
works great. I also want an individual to view records
by name and have made a form from which you can select a
name from a combo box and a subform which shows dept and
comments. This one gives me an error when I try to enter
new information "The property is read only and can't be
set". I press "OK" and the dept remains (drop down box)
and I can continue unhindered from that point on.
I've tried everything except the solution.
Thanks again.