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.

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
Manchester, England.



"MikeB" wrote:

> 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.
>

> 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 :-)

--
Wayne
Manchester, England.



"MikeB" wrote:

> 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.
>