Using a form to add new things to a database

[FBueckert]

I've created a form to make entering items into a table easier. Thing is, I don't want it to be used to edit entries, so I locked the text boxes. I'm trying to check for a new record whenever it switches records, and if it's a new one, to unlock all the fields. Any ideas on how to do this? Or a suggestion on a different way to do this?

EDIT: Also, to clear up confusion, I have a few comboboxes to make entering data easier. For locked controls, you can still pull down the comboboxes, so I changed them to text boxes. Is there any way to change them at runtime?

 

[ejstefl]

If you go into the Form properties, on the Data tab, there are a couple of things that might interest you: Allow Edits, Allow Deletions, Allow Additions.

For your purposes, you can set Allow Edits to No, and Allow Additions to Yes. This should do the trick.