display last record on a subform

G

gymphil

I am trying to display the last record in a subform, currently the subform
record dissapears when you're creating a new record on the main form
 
J

Jeanette Cunningham

gymphil,
this is expected behavior for a form and subform that model a many to one
relationship.
When a new record is created on the main form, there can't be any records on
the subform.
You don't expect to have any child records for a parent record that hasn't
been created or is only just in the process of being created.

So maybe I'm not understanding your question. Would you care to explain it
again.


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

Similar Threads

Saving a record in subform 5
First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Trouble associating parent form record to subform's record 1
Access Main form/Subform Navigation 0
new record in subform 1
display last record in a subform 4
VBA Syntax for subform record source change 6

Top