new record and form

[reportyemi]

When i click my command button to open a new record , My form opens with a
new open form BUT the subforms or query inside my new form still have
record from old record still there. What i want is a new record without all
the old record. What am i doing wrong. I checked the command for open new
record and it looks fine

 

[Duane Hookom]

Do you have anything set in the Link Master/Child properties of the subform
control? If so, do you have any records in the child table that contain Null
in the link child field?

 

[reportyemi]

Thanks for responding. So i have both a subform and a query embedded in my
main form and both continue to give me old record. The main form itself
clears old record and is ready for new information. The subform doesnot have
anything in the link master nor in the child master field. The embedded query
does have "MRN" in the child link field. MRN is a data in my main form

 

[Duane Hookom]

The subform will normally display all records unless a filter is applied
using the filter property of the subform or the link master/child properties
of the subform control or some type of criteria in the subform's record
source.

The subform's Data Entry property can be set to Yes to hide all previously
entered records.

 

[reportyemi]

Thank you Duane!

The subform will normally display all records unless a filter is applied
using the filter property of the subform or the link master/child properties
of the subform control or some type of criteria in the subform's record
source.

The subform's Data Entry property can be set to Yes to hide all previously
entered records.