ComboBox modification of Table

[campbelldw]

So I have an Access 2013 database which is using a combo box to provide a selection of options from which to generate a report based on the selection. This functionality works but it seems that when options are selected, the last which is selected modifies (replaces) the 1st entry in the table from which the combobox draws its options.

Example: combobox has options a, b, c, d, e and the user selects e to generate report. Report generates but when the user goes back to generate another report the options now read out as e, b, c, d, e, with all items which previously listed under a now showing as e. Items listed under e previously also show up under e. When the table is opened the row for a is now e. The tables are linked on the ID which is the auto numbered default value in the created by Access.

My question is how do I prevent this from happening. I cannot lock for editing cause that prevents user from being able to select anything. The combobox is also has the limittolist property set to yes.

[PhilOfWalton]

Sounds as if you have the ControlSource set to a Table or Query
Try leaving it blank

Phil

[campbelldw]

WOW!!! I feel a bit sheepish now. That appears to have corrected the issue. I COULD NOT find it on Google what so ever. I looked for several days. Thank you very much.