How to get a selection from combo box entered as a new record on a datatable

[RobFlott]

I am new to MS Access and am trying to build a system where users open a Form and make selections from 5 different combo boxes. The entries that appear in each combo box come from separate fields on the 'List' table. I would like to set this Form so whatever the user selects from the combo box is automatically entered as a new record, into the similarly named field of the 'Data' table.

Can this be done in Access?

If so can anyone help me understand how to build this?



I am using MS Access 2010 32-bit

Thank you very much.

[June7]

Bind form to Data table, move to New Record row, select values of comboboxes, close form or move to another new record. Basic Access functionality.

[RobFlott]

Thank you for the quick response, but I cannot find where to select 'Bind' in the Form properties. Same for "move to New Record row". Are these code I need to write or are they options in the various tabs on the Properties sheet?

[June7]

Bind form by setting RecordSource property.

Move to new record with navigation bar at bottom of form.

No code is necessary to use these intrinsic features but code can customize these behaviors.

Sounds like you could benefit from an introductory book.

[RobFlott]

Thanks for your patience and sorry I didn't make myself clear. I simply want the end user to open a Form and make a few selections from the combo boxes which would automatically be recorded into the 'Data' table. And you are correct that I need an introductory book on Access, the one I have is not helping. I will look elsewhere.

Thank you

[June7]

If you don't want users to have to 'move' to new record row, set the DataEntry property to Yes and the form will open only to new record. However, users will not be able to navigate to existing records.