Search results

absolute genious - except it doesn't work for some reason. I can see in the property sheet that the default value IS changing to the current value but for some reason when I go onto the record it says '#Name?'. I don't know if this is maybe because the 'value' is actually text or maybe the fact...

I have a combo box on a form which looks up its options from a table. Usually the option chosen is the same as the last record, so I want to make the option chosen in the last record the default value in the present form to save time. I know I should probably use the 'default value' box in the...

no worry's, its sorted, just being a spanner...

I tried putting [Products].Requery in the afterupdate event of the first combo box but it still keeps saying 'can't find macro 'products.'' Also tried forms!input!products.requery but that didn't work either, it just said can't find macro forms!input!products Also requery doesn't appear in...

why is it in the wrong place, surely it should be in the afterupdate event of the first combo box? I did use the expression builder and the property sheet.

...correction, it won't pick up the second combo box. I put that code in the afterupdate event of the first combo box.

I tried that, I put: products.rowsource = SELECT prod FROM products WHERE Cat=forms!input!category; (products is the second combo box) but then it just said 'can't find the macro 'products'', for some reason it won't pick up the first combo box, and its really annoying

I am (still) trying to make the contents of a combo box change depending on what you choose in another combo box (which is actually a value-list lookup). The data for the combo box is in a table called products, with fields cat (for category) and prod (for products), a bit like this: Cat...

I don't think there is a field for each product... using the fruit and cars example, I have a table called products or something which has field names cars, fruits etc. (i.e. along the top) then each column lists the type of product, so under cars would be mazda, then ford, then lada and under...

I understand what you are getting at because I use visual basic but I don't really know how to point to the right information for the second combo box. There is a table in the database with the product types as the heading and then the actual products underneath these, so in the first combo box...

Hi, I am new to access and have been trying to do the following for ages - how do you link two combo boxes together in Access so that choosing an item in the first box will change the list displayed in the second? E.g. you choose 'cars' in the first and the second box has the options 'Ford...