Forms and subforms

  • Thread starter Thread starter ddoblank
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
Back
Top