Open form to a new record

[DarkProdigy]

hey guys, was wondering the coding so that when a form is opened, it automatically sets you up with a blank record. This thread has probably already been done, but I would appreciate any help

 

[KenHigg]

You can set the 'Data Entry' property to true. Would this work?

 

[DarkProdigy]

How would I go about doing that Ken, I'm extremely new to Access and have never done andy VBA coding before

 

[DarkProdigy]

Would basing this form on an append query do it for me?

 

[KenHigg]

Would basing this form on an append query do it for me?

Hum... No. Will you be using the form for any thing BUT adding records?

 

[DarkProdigy]

No, this form is solely for adding new records, I have an alternate form for modifying records that's based on a parameter query. I'm going to use a switchboard similar to the Northwind sample so that the interface is painfully simple

 

[DarkProdigy]

Any ideas? I know it can be done, I just don't knonw how

 

[Bat17]

Access will do it all for you then

Tools>Database Uitilities>Switchboard Manager.

When you create a button to open a form you get a choice of Add mode or Edit mode so you can use just one form and use the switchboards abitlity to control the way it opens.

HTH

Peter

 

[DarkProdigy]

How do you create a switchboard Bat? All I thought it is was just a form with buttons that open up other forms. What's the difference between that and a "switchboard"?

 

[KenHigg]

If you pull up the form in design view and look at the forms properties, you'll see a property - 'Data Entry'. Set this to Yes. If you can't get this far, maybe you should purchase a good Access book.

 

[DarkProdigy]

I figured a work-around for the blank record entry, thanks for the help Ken. However, this whole "switchboard" think has peaked my interest. Does changing it to an actual switchboard make it more efficient than just using a regular form to do the same thing?

 

[Bat17]

Simpler, especialy with lots of sub menus.
What it does you can do in an ordinary form as well.

DoCmd.OpenForm "myForm", , , , acFormAdd
will open your form in Add mode. look up OpenForm in help (from a module!) to find all of its arguments.

Peter