On Open Event

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

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?
 
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:
 
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.
Click to expand...
[quoted text clipped - 6 lines]
Can someone help me with an On Open Event or any other suggestions?
Click to expand...
Click to expand...
 
Back
Top