Minimal Data Entry

[ekrobi]

I have a simple table with employee, orderdate, and order. I need a form for adding new entries easily. I created a form for bringing up historical data using a combo selection for the employee and a date calendar that they can point and click a date and bring up all orders for that employee based on a certain date.

I want a similar concept for adding new records but have so far not been able to do it. My primary keys are badge, orderdate, and order because of the multiplicity of orders that could be under an employee on the same day. Is what I'm wanting possible for new records?

 

[Guest_imported]

Hi,
I don't understand. How is it possible to bring up new records for a specified date? Past records you can bring up. New records must be added freshly. If you could be a little more elaborate that I can understand better, I think we can conjure up some way to tackle your problem, whatever it might be.

 

[tunsarod]

My preferred way to data-entry for complex records where you may want to check the data before committing it to the table is this.

If you are happy with the existing layout of the form you use to view individual records then use that but otherwise create a form with all the fields necessary to add a complete record BUT remove the control source statement for all fields: make them all Unbound.

Design an Apppend query that adds a single record to the table using the data from the new form fields. Refer to the fields thus: Forms!NewForm!Badge or Forms!NewForm!Employee, etc.

Place a command button on the form that activates the query using Docmd.RunQuery "NewAppendQueryName"

Lastly make sure that the new form is not bound to the table. this method uses the form as a kind of note-pad to paste the new records details then, when you are good and ready, the entire record is added to the table. The normal process with Access using the default AddNew record procedure is that the moment any field is filled Access creates the record so it's very easy to end up with records that have errors or are simply incomplete.

Rod