Hi Guys - back again !

I have created a fully formatted VBA data entry form with relevant combo
boxes; labels etc etc. I hav a command button to close the form

I now need to place a command button that will update the database with the
information entered in the form.

My database is 10 columns in width, however data entry is only 4 fields so
copying the information as a new record has to be to specific to relevant
columns

eg drop down gives a list of names so that record must copy the name to the
"name" field in the database.

I have read quite a lot of the "contextures stuff" and used some of Dave
Petersons work/examples but am really struggling with this one.
Any help much appreciated

Hope I have given you enough detail

thanks in anticipation
Roy


--
thanks
Roy