Subform

B

bdehning

I need help

What do I need to do in design mode when I have a subform linked to a form
and I do not want to see previous entries in the subform but want the ability
to be able to enter the 3 subform fields in any order at anytime the form is
opened?

I do need to see data in fields in the main form as the fields in the
subform relate to those records.

I have tried event procedures for new record on form entry with no success?
 
B

bdehning

Issue solved. I finally used the docmd new record in the on current property
and it worked liked I wanted.
 
J

John Vinson

Issue solved. I finally used the docmd new record in the on current property
and it worked liked I wanted.
Click to expand...

That's one way; it allows the user to scroll back and see older
records, though. If you want to prevent that set the Data Entry
property of the form you're using as a subform to Yes.

John W. Vinson[MVP]
 
Top