Force New Record

L

Lin

Hiya All and thanks in advance.

I have a main form with the autonumber key field on there, also 4 embedded
subforms.

When I open form and start entering new data (record), it starts with
(subforms) but I do not see the autonumber advancing on the main form. I
have set it up for
on open go to new, but it does not populat main form only subforms. I do
have them linked (Main and child) by autonumber field. Is there a way to
force the new number on main form before I start entering data into subforms?

Thanks again.
Regards
 
S

Steve Schapel

Lin,

Do you mean the Autonumber field is the only field represented on the
main form? Is this the only field in the table that the main form is
based on? Essentially the concept is that you will have to enter data,
programmatically if necessary, into another field in the main form's
underlying table, in order to force the creation of a new record.

If you need more specific help with this, pleasepost back with more
detailed description of the data for the main form and subforms and the
relationships between them.
 
L

Lin

Hi Steve, thanks for reply.

I have a few other fields but they are not mandatory for input. I was
wondering how to do this programmatically.

There is one field where you could select the status i.e: "Open", "Brief",
"Ref"
However, this is a drop down based on combo. Could this be what I use?????

Or....would someone actually have to key into the field?

Most of what is on the main are descriptive aspects of file.

Thank you
 
S

Steve Schapel

Lin,

I am not really getting a picture of what you are doing. You have
subforms. Presumably these are based on tables which are related
many-to-one to the table that the main form is based on. You apparently
want to create child records in the subforms, and therefore need a
record in the main form that they can relate to. Am I on the right
track? Well, you can't have a record in the main form without entering
some data in there. I do not understand "I have a few other fields but
they are not mandatory for input". I mean, I understand the meaning of
the sentence, but I don't understand the concept of having a table/form
with no data entered.

As I mentioned before, if you need more specific help with this,
pleasepost back with more detailed description of the data for the main
form and subforms and the relationships between them. Thanks.
 
Top