Subform problem

  • Thread starter Thread starter Merwin12
  • Start date Start date
M

Merwin12

I created a subform within my main form and everything is
okay. Records are saved and showing.

The problem is I cannot go to the subform not
until I filled all required fields on the main form.
Main form's before update event fires when
the subform receives the focus.

How can I fix this??
Help is appreciated.

Thank you!!!!
 
I understand your problem, I just don't understand why this is a problem for
you.

When you leave the main form, Access automatically saves the current record
showing in the main form (saves it into the table that is the recordsource
of the main form). Whoever designed the application (you or someone else?)
specified that certain fields are required to be filled in within that
record and Access is requiring that you fill them in before you can save the
record. That's what it means to say that a field is required.

Why wouldn't you want to fill in all the required fields before you go to
the subform??
 
The main form is a long form and the subform is on top.
Logically speaking, we can't move the subform to the
bottom of the form as this needs to be answered before
moving on to the rest of the form.
Its not a big deal as you said but just cumbersome to use
on the client's side. If there is no other way, I guess
they just have to live with it.

Thank you for your insight!!!
 
Back
Top