Enabling a query-based form to enter new data | Access forum

Resolved · Urgent Priority · Version 2007

Wed 28 Mar 2012, 17:03 Delegate Paul said...

Paul has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course

Enabling a query-based form to enter new data

I've created a form using a query that crossses three tables. It displays existing data fine, but I am unable to enter data in the 'new record' form. As far as I can see the fields are enabled for text input on the field properties. How do I enable the form to add new records? And is there a way of adding controls to the form to select data from the three tables whch does not elimnate pre-populated data in the form?

Mon 2 Apr 2012, 09:39 Trainer Simon said...

RE: Enabling a query-based form to enter new data

Hi Paul,

Thank you for your question.

Have you created a sub form? Have you looked at the form properties to try and enable data input?

In response to your first question, try creating a macro that opens the form in Add Mode and see if that sorts the problem out.

The second question may need a little more thought.

Regards

Simon

Thu 13 Dec 2012, 11:08 Trainer Cindy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 20 Dec 2012: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.