Data Entry Interface (Create New Record) Help

[usermj]

Could anyone of you give me some sugguestions on designing a nice/efficent Data Entry interface (Form design) for adding new records?:


I have bound a Form with a table and linked all the textbox with the relevant fields in the table. I created a add new record button through the wizard provided by MS-Access as: DoCmd.GoToRecord,, acNewRec.

While, each time when I opened that Data Entry Interface, the current always pointed to the first one rather than leaving the blank field for data entry. Even I changed the value in those textbox, the system didn't create a new record in the table at all, only modifying the first record.

I know how to write the VBA code to open table and add new records by retrieving data from the Form interface, but I wonder whether there is more efficent solution by combining the default function/facilities from MS-Access itself and some VBA code. Also, it can have some validation before storing data into the tables.

Many Thanks

 

[trucktime]

New Record

In Design View, go to Properties/Data Tab and set Data Entry to Yes.
That way you will see a blank record when you open the form.

It is good policy to use a query as record source for the form instead of a table.
That way you can retrieve only those records you need (select), you can manipulate data in the query (combine or split fields), sort and ad calculated fields.

Data validation should be done y puting some code in the Before Update Event of the form. Search the forum, there are many posts on that topic.