new record and form

R

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
 
D

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?
 
R

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
 
D

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.
 
R

reportyemi

Thank you Duane!

Duane Hookom said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top