Forms and subforms

[ddoblank]

Hi, I have created some forms with subforms and I have a problem with the
data being changed in the original table when you type in a value in the main
form to display the related info in the subform. I don't want the main form
to allow the data to be changed in the original table. Only want data to be
entered into the subform. How can I do this?
Thanks
Darren

 

[John W. Vinson]

Hi, I have created some forms with subforms and I have a problem with the
data being changed in the original table when you type in a value in the main
form to display the related info in the subform. I don't want the main form
to allow the data to be changed in the original table. Only want data to be
entered into the subform. How can I do this?
Thanks
Darren

Controls whose only purpose is to find a record, or filter records, or to
serve as a Master Link Field for a subform... should (or must!) be unbound,
i.e. have nothing in the control's Control Source property.

My guess is that your main form is bound, and/or you are using bound controls
with the intent on displaying a subform record; but with a bound control
you're also editing the field in the mainform's table.

 

[ddoblank]

Thank you John, that was the problem exactly.

darren