variable

[Guest]

I have a table(ques) with colums qno,questions,group,ptep and ptep_phase.
ptep_phase is a sub group of ptep (ie one ptep can have many ptep_phase).

I have two combos in my forms (ptep and ptep_phase) and i am trying to
populate records for the second combo (ptep_phase) on change of ptep combo.
one more thing i need to retrive records containing words which iam going to
give in a text box (like search) if i use a query like


select questions fron ques where questions like'*how*';

it is reterving records containing the word "how" but if i want that word to
be entered through a text box .how to do it ????

 

[Guest]

For the cacading combo's check this link

http://www.databasedev.co.uk/filter_combo_boxes.html

For the part string filter, use the Like in the query

Where FieldName Like "*" & Forms![FormName]![TextBoxName] & "*"