Command button on form

[Guest]

I would like to put a command button on my switchboard form that will open a
blank data entry form that is ready to enter data. I have a button to open a
filtered from according to the subject chosen from a combo box. I also want
to create a button that will give the user a blank entry form, not all of the
records associated with that form. Normally if you create a command button to
open a form it will open the form with all of the records for that form. Is
there an easy way to do this. I am using Access 2003.

Thanks in advance for your help.

Best regards,

Dee

 

[kingston via AccessMonster.com]

Change the Data Entry property of the form to Yes. Do this either in design
mode of the form or as part of the command button's code (DoCmd.OpenForm ...,
acFormAdd).

 

[Guest]

Kingston is correct about setting the Data Entry property of the form;
however, if you are actually using the Access Switchboard, then this should
not be an issue. The question asked is usually the other way around, because
when you choose the OpenForm action in the Switchboard manager, the default
mode is Data Entry. You actually have to be carefull to select "Open in Edit
Mode" to be able to see all the records.

Is it possible you have your own menu form you are calling a Switchboard?
A User defined form is not a Switchboard.

 

[Guest]

You are correct. I didn't use the switchboard manager to create the
switchboard. I just used a form and added command buttons.

Thanks very much for your help.

Best regards,

Dee