Subform problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Merwin12 - 21 Feb 2005 19:50 GMT

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!!!!

Reply to this Message

JP - 22 Feb 2005 02:17 GMT

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

> I created a subform within my main form and everything is
> okay. Records are saved and showing.
[quoted text clipped - 8 lines]
>
> Thank you!!!!

Reply to this Message

Merwin12 - 22 Feb 2005 13:34 GMT

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!!!

>-----Original Message-----
>I understand your problem, I just don't understand why this is a problem for
[quoted text clipped - 24 lines]
>
>.

Reply to this Message