Form/subform issue

  • Thread starter Thread starter joet5402 via AccessMonster.com
  • Start date Start date
J

joet5402 via AccessMonster.com

I have successfully (I think) created a subform that synchs with a main form
and it's records; I've also created a command button for this subform to open
after opening the main form; however, when I create a new entry in the main
form, it does not synch with the subform. Why does the subform not synch with
the new entry?
 
joet5402 said:
I have successfully (I think) created a subform that synchs with a
main form and it's records; I've also created a command button for
this subform to open after opening the main form; however, when I
create a new entry in the main form, it does not synch with the
subform. Why does the subform not synch with the new entry?

If you are opening it then it is not a subform. A subform is a form that is
embedded within another form using a subform control. What you have is a
plain old form that you are filtering when you open it. As you can imagine,
applying a filter only affects the existing records you see. It does
nothing concerning NEW records.

If you use a real subform then new record handling is automatically taken
care of. If space is a concern then use a TabControl.

You can "sort of" get an external form to behave much like an embedded
subform, but unless you have compelling reasons not to use an actual subform
it is better to do so.
 
I was able to create a subform via the toolbox, but I was also able to
configure it to appear as a regular form, then create a command button on the
main form to open the second form. So technically, you're right.
Is there a way from here to synch up the two forms to where the new records
show up?

(Sorry, I've never been super in-depth into Access and it's million
intricacies).
 

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

Back
Top