add new record in table with textbox and combobox without button

[feeder23]

Hi,

is it possible to add a new record by opening a form with 3 textboxes en 2 comboboxes.

First, i push on the button, new record and then I fill in the 5 boxes and this should give one new record. The big problem is to make this all as 1 record.

Or, has anyone another structure for adding this new record.

greetz

[dannymking]

What do you mean ? by 5 controls to one record.. are you trying to concatenate all the values into one record?

[RobDog888]

Or all the values to one Field?

[dannymking]

Mis-type again...

I'll be getting as bad as noteme soon...

[RobDog888]

Nope, I am next in line for the NoteMe speling award!

[feeder23]

yes, these 5 controls place in just one record

so one field is autonumbered, and 2 textboxes (to put text in it) and then 2 comboboxes (both with autonumbering and text, the combobox will display the autonumbering after choosing the right text in the combobox

and then all these 5 controls put in one record

greetz

[RobDog888]

Can you give an example of the before and after? A record has multiple fields. Do you want that or all values in one field?

[feeder23]

all these 5 in one record but in 5 different fields.