Have form open to accept a new record

[rpbsr]

I have a main form and a main form with subform. I would like these to open
ready to receive data, rather than populated with data from the first record.
I appreciate any help.

Thanks,
Robert

 

[Klatuu]

Use the Data Mode argument of the OpenForm method and set it to acFormAdd.

 

[rpbsr]

Dave,
This sounds like a VBA solution, which I'm not very good at (but can
follow). Can you post an example? Does this use the OnOpen event?

 

[Klatuu]

If you prefer to use a macro, use the OpenForm Action and select Add in the
Data Mode box. It requires nothing in any form event.

 

[rpbsr]

The forms I'm referring to are opened from my switchboard, which use the
following OnClick events (=HandleButtonClick(number)) to open the form(s). It
sounds like you are suggesting I have the OnClick fire a macro to open the
form in Add Data Mode. I can see how this would work. Is my understanding
correct and will it adversely affect the Switchboard Table?

 

[Klatuu]

You don't even have to do that.
If you are using the Switchboard, Open the Switchboard manager and you can
select an option to open a form in add mode.

 

[rpbsr]

Perfect, thanks Dave!

You don't even have to do that.
If you are using the Switchboard, Open the Switchboard manager and you can
select an option to open a form in add mode.