Ok, so I'm REALLY confused! And have no idea how to describe my issue so am hopefully (!) attaching a copy of my db.
Basically my problem is with "Product creation Form Part 4"
It is designed to show various details of products from various suppliers. And works like that
In the subform, where it shows the info, I can swap the supplier (via the combobox) and the supplier's codes for the products swaps (suppb has lots, suppa has none)
I can limit what is shown in the subform by using the comboboxes in the main form. Eg, under 'lifestage' if I select "puppy", only the products suitable for a puppy are shown.
While this happens, I can still swap the codes between suppa and suppb.
What is weird though, when I cancel the selection in the main form (either by selecting the combobox choice again and hitting delete, or using my "clear" button), even though I believe everything returns to how it was before, the suppa and suppb option no longer does anything. It always shows suppb's codes.
I've spent ages going around and around and as I say, I believe I've compared all settings etc and can't for the life of me understand why the combobox suddenly stops working.
Would LOVE your help,
thanks loads xx
Basically my problem is with "Product creation Form Part 4"
It is designed to show various details of products from various suppliers. And works like that
In the subform, where it shows the info, I can swap the supplier (via the combobox) and the supplier's codes for the products swaps (suppb has lots, suppa has none)
I can limit what is shown in the subform by using the comboboxes in the main form. Eg, under 'lifestage' if I select "puppy", only the products suitable for a puppy are shown.
While this happens, I can still swap the codes between suppa and suppb.
What is weird though, when I cancel the selection in the main form (either by selecting the combobox choice again and hitting delete, or using my "clear" button), even though I believe everything returns to how it was before, the suppa and suppb option no longer does anything. It always shows suppb's codes.
I've spent ages going around and around and as I say, I believe I've compared all settings etc and can't for the life of me understand why the combobox suddenly stops working.
Would LOVE your help,
thanks loads xx