Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » CREATING FORMS

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

CREATING FORMS

Resolved · Low Priority · Version 2007

Reply Tue 17 May 2011, 11:45Delegate Sarah said...

Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

CREATING FORMS

I have created a form in a database to enter customer details.
However when I open the form it opens pre-filled with the first record from the customer table. How do I get it to open at a blank form so I can enter a new record?

For upcoming training course dates see: Pricing & availability

Reply Wed 18 May 2011, 09:37Trainer Simon said...

RE: CREATING FORMS

Hi Sarah,

Thank you for your question.

If you open the form in Design View and click on Property Sheet which is situated at the end of the Design Tab.

Navigate to the Data Tab and select 'Yes' from the Data Entry Property.

Everytime you open the form it will be in Add Mode and the records are hidden. If you want to view the existing records using the form then change the Data Entry property back to No.

I hope this answers your question.

If this does answer your question could you please mark the question as resolved.

Regards

Simon

Access articles

· MS Access and Database Normalisation
· Microsoft Access Tighten your Security Controls
· Discover the Secrets within Your Business through Microsoft Access Training
· Insert A Real-Time Clock In An Access Form
· Microsoft Access as a Business's Database Management System

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips