On Open Event

[ladybug via AccessMonster.com]

I have a form called frmChangeControl. In this form is a series of tabs with
different subforms. One subform is called sfrm_rom.

In this subform there are multiple text boxes. The first one is called
cc_number. This is what links frmChangeControl and sfrm_rom. The second one
is rom_number. This is an autonumber that is created once data is entered in
any of the other textboxes on sfrm_rom.
I need this autonumber to calculate as soon as frmChangeControl is opened.

Can someone help me with an On Open Event or any other suggestions?

 

[Klatuu]

An autonumber field is not populated until a new record is created. If you
want a new record in your subform, use the Load event rather than the open
event:

 

[ladybug via AccessMonster.com]

Can you explain further in how to use the Load Event? What kind of code?
Thanks for your help!

An autonumber field is not populated until a new record is created. If you
want a new record in your subform, use the Load event rather than the open
event:

I have a form called frmChangeControl. In this form is a series of tabs with
different subforms. One subform is called sfrm_rom.

[quoted text clipped - 6 lines]

Can someone help me with an On Open Event or any other suggestions?