Re: filters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

i will try to revise the macros based on your hints. i hope it will work out
this time, otherwise i will post a detailed question.

thank you very much anyway!!!

Ο χρήστης "Steve Schapel" έγγραψε:

Angie,

Just a hint: When providing examples in newsgroups, it is always best
to give the *exact* information. If possible, copy/paste from your
database.

I do not understand what ControlName refers to in the GoToControl
action. It can't be the one you want to make visible, I presume,
because if it is not already visible, the GoToCOntrol will fail.

As regards the SetValue action, it looks like you have missed out a ']'
at the end of 'FormName', so that might be the problem. Otherwise, if I
understand you correctly, the arguments would be like this:
Item: [ControlName].[Visible]
Expression: Yes

If this doesn't help, please try to explain exactly what you want, using
the names and values of the controls.

As regards the comboboxes and the ApplyFilter macro, once again it is
very difficult to answer with no details to work with. But I think you
will need something like this as the Where Condition argument of the macro:
([SomeField]=[Forms]![YourForm]![FirstCombo] Or
[Forms]![YourForm]![FirstCombo] Is Null) And
([AnotherField]=[Forms]![YourForm]![2ndCombo] Or
[Forms]![YourForm]![2ndCombo] Is Null) And
([FredField]=[Forms]![YourForm]![3rdCombo] Or
[Forms]![YourForm]![3rdCombo] Is Null)

--
Steve Schapel, Microsoft Access MVP

angie wrote:
it is a check box and the arguments of the macro are:
GotoControl = ControlName (field name) and then
SetValue: item = [Forms]![FormName![Field name]
expression = [Forms]![FormName].[Visible]
i have assigned the macro both on the on change and on the after update
event but it is not working.
p.s. in the form the i have set the field's property as not visible. i want
it to become visible only with the checkbox.

how about the combos and the multiple filters? how can i make them work
"tpgether"? i do not have a clue about SQL that' why i want to use the macros!

.

Relevant Pages