AutoNumber problem

[soklear]

Hi. My question is regarding a form that has an autonumber field that doesnt populate until data is entered on the form.

Is there a way to force the autonumber to populate immediately when the form is opened? The reason being is that there is a sub-form that is linked to the 'uniqueid' field of the main form. When a user goes to the sub-form and enters data before populating the main form, and then clicks out of the sub-form - all the data is lost that was just entered (because of the UniqueID field being linked).

Ive tried a docmd.save and other methods but just cant seem to get it right.

Any help would be appreciated.

Thanks.
Bob

 

[Remou]

Would it not be more natural, and safer, to force the user to complete a relevant main form field before entering data in the subform?

 

[TheAceMan1]

How are ya soklear . . .

The rule is: [blue]You can't enter data in a child table without a matching link ID field in the parent table.[/blue]

If your entering data in the subform 1st then there's something wrong with your table structure! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[soklear]

On both points. Absolutely.

I have attempted to 'lock' the subform until at least one field (say, the vendor name) is inserted. I am not experienced with VBA so, I may have done something wrong.

Secondly, the matching id (UniqueID) from the first table is the matching link id on the subform. The problem is that, the matching link ID is a primary key called workerorder number on the parent form and the secondary table uses this field to link between the two.

 

[Remou]

How did you try to lock the subform? You could use the On Enter event of the subform control to check the main form.

 

[soklear]

I believe i just used the on focus event. I will try that and let you know.

-Bob

 

[acent]

You could set the subform to enabled = false and then play with something like:
if me.dirty then
subform.enabled = true
end if

Hope this helps.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[soklear]

The 'On Enter' worked like a champ.

Thanks for all your help, especially, Remou.

-Bob