Combo box to select records

[blueboy2001]

This is so simple, but I'm losing the will to live at the moment with my current Access project.

I've got a form for inputting details into a table on. I've put a combobox at the the top that lists the records, all I want to do is be able to select a record from the combobox and view the details on the form. I can get the list, but the combo won't let me select anything and gives the error message "Control can't be edited, its bound to AutoNumber field DriverID".

Where am I going wrong?

 

[dcx693]

Because you're using the combo box simply to select a record to view, it needs to be an unbound control, meaning that it needs to have a blank controlsource, meaning that it will not be directly tired to a field from your table/query.

When you make a selection from the combo box, you don't actually want to change any values in any tables, you just want some actions to take place.

 

[blueboy2001]

Ok, I've unbound the combo box but it has no effect on selecting the correct record.

What do I need to add to it so it will select the appropriate record?

Edit - Some code might help I guess!

 

[dcx693]

Try looking at this: Have the form move to the record selected in List/Combo box