Allen;
I am looking for some code to filter a listbox using a drop down list. My
list box shows several columns.
tag_id; TAG; Description; Manufacturer. for example
I would filter on tagid type where Left string of the first few characters
will indicate the tag type:
Example:
mm03-ty-01 , m% would indicate a motor (Which have own set of re****ts);
left$(Tagid,1) = m
sg01-FY-02 ; S% would indicate a switch. (all back end tables are in SQL
thus the % for a wild card)
The list is filtered to all possible types that start with an S or M or
anything else.
Then I would use the Selected items to print a re****t the related re****t
based on the Tag type.(M for motor
Motors have their own re****t, switches have own re****ts Etc. Currently
re****ts are in word, I'll have to recreate them as access re****ts as I
don't
know how to print on word do***ent straight from Access. At any rate
re****t
select/print criteria is based on the type of the element Id or Tag ID
I would appreciate any help with real code example. .
P.S: I have the print selected list items on a single re****t working
fine,
but not on a designed re****t in Word. Would it be faster to make these
word
forms into Access re****ts?
Thanks
