T
toaster
Hi,
I have a combobox on an orderitems subform to allow a user to select
products for order lines on an order.
I have checkboxes on the main form to allow the user to filter to
products from preferred suppliers only (a boolean field in a link table
betwen products and suppliers) and to filter out discontinued products
(again a boolean value).
The subform displays continuous records of all order items.
The problem: When the 'View Preferred Supplier Products Only' filter
checkboxe is switched on, the values in most of the previously selected
order items disappears (because not from the preferred supplier)
The combobox recordsource is filtered correctly and I presume this is
the problem, as it is bound to the unique identifier for the selected
product/supplier combo.
I have tried adding an unbound field and filling that with the name of
the product when a product is selected, but it is added to all rows
(I.E. not unique to the current record)
I want to avoid having to add an extra 'product name' field to the
underlying orderitems table, as the unique identifier for the products
should suffice and I'm trying to avoid excess unnecessary data.
I'm sure there's a simple solution to this - apologies in advance if
I'm being daft. Ive searched at length for this but can't find anything
obvious...
toaster
PS please don't be offended by the e-mail address -it's just tough to
come up with something unique on hotmail - I'm veggie and love marine
mammals
I have a combobox on an orderitems subform to allow a user to select
products for order lines on an order.
I have checkboxes on the main form to allow the user to filter to
products from preferred suppliers only (a boolean field in a link table
betwen products and suppliers) and to filter out discontinued products
(again a boolean value).
The subform displays continuous records of all order items.
The problem: When the 'View Preferred Supplier Products Only' filter
checkboxe is switched on, the values in most of the previously selected
order items disappears (because not from the preferred supplier)
The combobox recordsource is filtered correctly and I presume this is
the problem, as it is bound to the unique identifier for the selected
product/supplier combo.
I have tried adding an unbound field and filling that with the name of
the product when a product is selected, but it is added to all rows
(I.E. not unique to the current record)
I want to avoid having to add an extra 'product name' field to the
underlying orderitems table, as the unique identifier for the products
should suffice and I'm trying to avoid excess unnecessary data.
I'm sure there's a simple solution to this - apologies in advance if
I'm being daft. Ive searched at length for this but can't find anything
obvious...
toaster
PS please don't be offended by the e-mail address -it's just tough to
come up with something unique on hotmail - I'm veggie and love marine
mammals