Adding records through a form

[MikeB]

Help me get my head around this.

I have a table of Players. I might have to add players, or update
something about them.

My current form is OK, but I don't think it is simple and
straightforward. There is an Add button, that I added using the
Wizard. It clears all the fields and the number field shows (Autonum).

Do I have to press the button again to actually add the record?

If I type into the fields before I press the add button, do I
overwrite the record that I'm currently positioned at?

Why does certain drop-down combobox items not reset when I hit the Add
button? Do I have to add code to an event to rest the combo boxes? In
fact, even if the combobox values display correctly, if I don't
reselect the value in the control, the field in the DB doesn't seem to
update correctly.

Would it make more sense to write a custom button that opens a new
form for adding new records?

Thanks.

 

[Wayne-I-M]

Hi Mike

Do I have to press the button again to actually add the record? Yes

If I type into the fields before I press the add button, do I
overwrite the record that I'm currently positioned at? Yes

Why does certain drop-down combobox items not reset when I hit the Add
button? Do I have to add code to an event to rest the combo boxes? In
fact, even if the combobox values display correctly, if I don't
reselect the value in the control, the field in the DB doesn't seem to
update correctly.

Don't know - how are you "filling" your combo boxes at the moment. Are they
filter by the record ?
Can you give more details

Would it make more sense to write a custom button that opens a new
form for adding new records?

No

 

[Wayne-I-M]

My current form is OK, but I don't think it is simple and

straightforward. There is an Add button, that I added using the
Wizard. It clears all the fields and the number field shows (Autonum).

This is a new record

Good idea >>>> Open the form in design view and select the autonumber field
(the ID) open the properties box and in the Visible Row select = NO
You don't need to show the ID (Primary field) to a user. It is ONLY used as
a unique identifier for the record - in most cases