Forum Discussion
Automated Form for use with Microsoft Excel Table
I am new to using Microsoft Excel Tables. However, I did create a table with a field named SalePrice. The entry in the first row is shown in the Table as $34,012.50. When I created a form for thi...
Sorry for the long delay in responding to your reply. I do not know how to access the Control Source property for the Data Form created by Microsoft. It seems this form appears magically by Microsoft Excel and I don't know how to access the basic form to modify it. Any suggestions, I am rather frustrated at this point.
Thanks for your response.
Thanks for your response.
If the data form is there and you can't find it...
You can modify an Excel Data Form by adding the Form button to the Quick Access Toolbar.
To do this, click the arrow next to the Quick Access Toolbar, then click More Commands.
In the Choose commands from box, click All Commands, and then select the Form button in the list. Click Add, and then click OK .
If the data form is deleted/doesn't exist and you can't find it with it...
To create a new record using the data entry form in Excel, you can follow these steps:
- Select any cell in your table.
- Click on the Form button on the Quick Access Toolbar or on the ribbon.
- In the input form, click the New button.
- Type the information in the appropriate fields.
- When done, hit the Enter key or click the New button again. This will add the record to the table and get a blank form for the next record.
If you don’t see the Form button on your Quick Access Toolbar or ribbon, you can add it by following these steps:
- Click the arrow next to the Quick Access Toolbar, and then click More Commands.
- In the Choose commands from box, click All Commands, and then select the Form button in the list.
- Click Add, and then click OK.
Otherwise you would need to see the file in order to be able to say more precisely.
I hope this helps!