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...
Hi. So this is probably an easy one for a lot of you but it's killing me! I've found lots of similar-ish questions but can't get any answers to work :banghead:
SV = InStr(IdStrPart1, intID)
works for my variables. Both terms within InStr are names of variables - in this case they are both...
Ok so I know that multivalue fields are the devil's spawn but I can't think of another way around it :( and I'm stuck!
I have a table, 'categories' that consists of categories of products for sale and their id numbers, eg 1 Wet Food 2 Dry Food 3 Small Breed 4 Large Breed
When a product is...