Strange Subform Behavior

[egun]

My main form has several tabs in it. On one of the tabs I have a subform
that is an array of text boxes in which the user enters numerical data. When
I click in one of those boxes, and then try to go to another record in my
database using the "Next Record" button at the bottom of the window, nothing
happens - I don't go to the next record. Instead, the icon on the top left
of the form changes to the "You are editing this record; changes to the
record aren't yet saved." symbol, even though I have made no changes.

After that, the only way I can go to the next record is to switch to another
tab on the form, and then go to the next record. Any ideas as to what might
be causing this behavior? Why does Access think I have edited a record when
all I did was click in a text box? Why doesn't the "Next Record" button work?

Thanks,

Eric

 

[Dale Fye]

The first things I would check are:

Is the subform bound to the parent form via a master/child relationship?
Is the subform a continuous form or single form?
Is the subforms "DataEntry" property set to Yes?
Is the textbox you are clicking in (in the subform) related to a new record?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.