Question uno (1)
I have a table with around 60,000+ lines which gets updated every week. There has to be certain selections so I and others can get the relevant information ( the info we need) in just a few clicks.
I have made around 6 combo boxes that refer to each others selection i.e. if box 1 selects A box 2 only shows the possibly entries with the A value of box 1.
Now I am trying to create a subform based on the same table where combo box 1 till 6 get their info from. I would like the AfterUpdate event of combo box 1 , 2 ,3 ,4 5, 6 requery the subform table. Well that isn't that hard to do, what I find utterly annoying is that I have no clue how to make the subform look at the values entered / selected in the combo boxes? As I tried to enter in recordsource a select query WHERE [table]![col] like [Forms]![form]![combo] which resulted into #name errors.
Question 2
if I have a table like :
ID DATA MOREAnd I want to filter this on for example NAME, LOC, PHONE. Creating combo1 wouldn't be that hard, letting it search for name, group by and voila.
Name Peter
LOC UK
PHON 111..
Name Walter
LOC US
PHONE 222..
etc. etc.
For the LOC (combo2) it would be harder (thus hard I dont know how too, I have a easier, but less beautifull solution atm)as it should check the choice made in combo1 and select all LOC that have the same NAME as selected in combo1.
For combo3 it would be similar to it 2.
I hope any of you would be so kind to help a new one out since I am eager to learn acces inside out. If necessary I can upload a sample database so you have a better idea of what my problem is.
Thanks for the help, hopefully in the near future I can join you lot with handing out information to newer users.
Kind regards!