Search results for query: *

Is there any way to set up a parameter query which will search for part of a feiod rather then the whole feild? I am workign in 97 if that helps at all. Cheers.

Thanks everyone for all your tips so far. I think I almost have it. Table looks like this: Main Sub A 1 A 2 B 3 C 4 C 5 I have a form with 2 combo boxes Combo1 contains the data from Main...

hmm..okay I tried this.. maybe let me explain how I have the tables set up.... Table i Main Category lists al 8 main catefoies in this feild Main Category Subcategories Main Category A L Main Category A C Main Category B X Main Category C Y Main Category C L Ive...

Hmm.. I wrote the code as you did above, Alcar, but I keep getting the followign message when I run it .. Syntax erropr in query expression "Category = value selected from comboBox1" What do you think that is about?

I have two tables a main Categories and SubCategoreis. I have the sub categories table set up as follows: Pricing Admin 1 A 2 B Etrc I have a form. Combo box lists values in Main category table . No problem. the Second Combo Box I have is supposed...

okay.. any tips on setting up the expression that will choose the appropriate value to place in the combo box

I have a combo box on main form. i need to somehow set it up so that whatever value is chosen from the main combo box a sub category combo box is found and displyed (i.e. choose one out of a possible 10 combo boxes) and disply only that list of options. have tried sub forms and a macro or two...

Could try a reference form (which is actually a subform) that looks up the name and lists corresponding ID - won't show other values/IDs though.

Does anyone know how to set up a macro that will password protect entry into a form. Alll other forms within the dB are for general use. THX