List/combo box based on other selection

[Adam1970]

Hi
I hav a continuous form where I need a multiple choice selection which is filtered by an field.
This I have solved however because the combo box is unbound it does not work in continuous form mode.


Is there an alternative I could use?
I am a novice access user.
Thanks
Adam

[CJ_London]

Not clear what ‘does not work’ means

certainly an unbound control can be used in a continuous form but it will have the same result for every row

you need to explain more clearly what you are trying to achieve for alternative suggestions

[Adam1970]

Hi
When I select the entries in the combo box it changes all the previous entries to the newly selected option. I need to lock the original selected items so they do not update upon new entries within the continuous form.
I hope that makes better sense.

[June7]

An unbound control is not saving data to a field. The control will display same info for all records unless it is a textbox with a calculation.

If you want to provide db for analysis, follow instructions at bottom of my post.

[madpiet]

Hi
I hav a continuous form where I need a multiple choice selection which is filtered by an field.
This I have solved however because the combo box is unbound it does not work in continuous form mode.
Is there an alternative I could use?
I am a novice access user.
Thanks
Adam

Create a subform based on the table that's going to store the data. use a query as the source for the combobox, so that you cannot choose items that have already been added.
SELECT item
FROM SourceList s
WHERE NOT EXISTS (SELECT 1 FROM UsedList ul WHERE ul.ID = s.ID)