Search results

ah yes, that was a typo in my reply! there are 2 ways to select the supplier - the main form which uses the null bit, and the subform which doesn't. When there's nothing in the main form, the subform should revert back to working like it does before you try selecting anything in the main form...

It's set to 2 yes, but then when you change the drop down in the sub form to suppa, the tempvars changes to 2 and the form is requeried, but it doesn't change the data in the form. At the start, when you load it up before you use any of the drop downs in the main form, it also relies on the...

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...

Ha, solved it :) :) :) :) So your last reply got me thinking - I'm clearly crap at this explaining game! Did some thinking (after all, what is going to bed for!) and realised that my question pretty much boiled down to "how do I dynamically reference a variable created in VBA" Seeing as that...

when the form loads, it creates IdStrPart1. It's made by going through the recordset and pulling out the ID numbers of certain records. Idea is that I'll do that for IdStrPart1, IdStrPart2, IdStrPart3 etc where each set of ID numbers remembered is different. Private Sub Form_Load() '...

Bugger! Will try again!! How do I make Function SV(x, intID) SV = InStr(x, intID) End Function work? where x is a string which is the name of another string eg x ="IdStrPart1" and IdStrPart1 = "5, 7, 9" (I can't just pass "5, 7, 9" in, I have to use the name) and intID is a simple number Thx

That doesn't work Cronk, it gives 0 but should be 5. Will try jdraw, trying not to confuse myself even more! So, this all started because I have a (continuous) form that displays product data. A lot of the info is repeated over each row, ie brand name. I am trying to make my form look like...

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...

Ah ok. I think you're both saying the same, or similar things. So instead of saving the categories for each product in a multi value field, save it in a second table where each line is one category for one product. So the product is repeated over as many records as it has categories? I like, I...

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...