C
cwhitmore
I would like to create a combo box that would allow users to select reports.
Any suggestions?
Any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
This is for a list box, but I expect it would work with a combo box:
http://allenbrowne.com/ser-19.html
http://allenbrowne.com/ser-19.html
C
cwhitmore
You're right, i meant list box. Let me give it a shot. thanks for the help..
C
cwhitmore
your suggestion worked perfectly! Is there a way to show only the reports you
want end users to view?
want end users to view?
C
cwhitmore
your suggestion worked perfectly! Is there a way to show only the reports you
want end users to view?
want end users to view?
B
BruceM
I couldn't say. I remember seeing the link, and I passed it along. If you
are using the first method I expect you could name the reports you don't
want people to see with a z_ prefix or something, then adding:
AND ([Name] Not Like "z_*")
If you are using the other method, I can't even hazard a guess.
are using the first method I expect you could name the reports you don't
want people to see with a z_ prefix or something, then adding:
AND ([Name] Not Like "z_*")
If you are using the other method, I can't even hazard a guess.
H
Harry
Just create a small query from the table where the formnames are listed.
Create the combobox and link it to this query
Create the combobox and link it to this query