Designing a Safe and User Friendly Data Input Form

[TC]

Most of what you ask can be done using the standard (default) features of a
normal Access form. With the exception of your combo box thing, you need not
write any code (DoCmd, FinfFirst etc.) or SQL at all.

Try this:
- create a simple table & add some records to it;
- use the Form Wizard to create a default form for that table;
- play around with that form. You will see that it can add, edit, delete or
find records without the need for any code.

HTH,
TC

 

[Steve]

Hello, I am working on designing a database to view,edit,
add,delete and search for product descriptions (about
10000 records). When a record is modified, I need to
retain the old description in a separate history table.
Also, I need to give the user the option to cancel an
edit, new item or deletion. The users have not used
Access before and will have to be restricted to using the
form only.

To accomplish this, do I need to code everything using
the recordset or can I use 'DoCmd.GoToRecord , , acNewRec'
etc?

Is it best to add new items with a separate form or on
the main form?

I plan to use a combo box bound to the stock number field
to lookup products. When the user adds a record, how do I
move the combo box to the new item?

Finally, I want the user to be able to search for a
description by text that can be in any field. If a match
is found, I want them to be able to edit the record. Can
I use Findfirst to do this or should I use SQL?

Thanks!!