Change the look of a form; pass parameters from form to Query

[stevehoyle]

I've already built the form so I can't select a new theme. How do I change the themes, or could I change the look of each part of the form. The contrast and ease of viewing separate rows is not good.

Also, how do I pass parameters from a form to a query? I have a query that directly references the form controls (form!Formname!controlname) but the query can be used by multiple forms if I can pass the parameters.



Thanks

[June7]

Did you use wizard to build form? I never do. My experience has been that once a theme is applied, can't get it to go away. Wizard 'groups' controls. Select all controls by left click sweep, then right click > Layout > Remove. Now you can move and resize controls individually as you wish.

Parameterized query is one method to filter, examples:
http://datapigtechnologies.com/flash...mtoreport.html

http://datapigtechnologies.com/flash...earchform.html

http://datapigtechnologies.com/flash...tomfilter.html

Other methods will require more VBA.