All,
Is it at all possible to have a 'multiple items' form based on a query, plus have a combo box added to it, with the control source of a field already on the form.
Issues:
When the combo box is given the control source of a field already on the multiple item form, the combo box can no longer be updated.
When the combo box is not given the control source, it can be updated but then it does not load the initial value of the control source field.
Major issue:
- When the combo box is updated for a record on the multiple item form, it then updates all of the other combo boxes for each record.
I've been working with Access for quite a long time and always put it down to Access not being powerful enough, whereas I could do this in Java in a few minutes.
Hope someone has an answer to this odd one.
Steph