If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
new navigation control Access 2010beta
Hi everyone again,
there is a new 'navigationbar' (correct translation?) control coming with access 2010 forms. Does anybody know how the 'Where-clause for navigation' property works? I thought it could be something like the Where-clause argument of the DoCmd.OpenForm procedure. So I added '[myField]100' where myField is a field name in the target form. But nothing changes. The target form always shows all records unfiltered. Thanks, Lorenz |
#2
|
|||
|
|||
new navigation control Access 2010beta
"Lorenz Hölscher" wrote in message
... Hi everyone again, there is a new 'navigationbar' (correct translation?) control coming with access 2010 forms. Does anybody know how the 'Where-clause for navigation' property works? I thought it could be something like the Where-clause argument of the DoCmd.OpenForm procedure. So I added '[myField]100' where myField is a field name in the target form. But nothing changes. The target form always shows all records unfiltered. The above works for me. I had to close/save the nav form, but then re-opening it did make the filter work. Also, don't use ' or ", try: [myField] 100 (no quotes needed) Of course, if myField is a text field, then use somthing like: [myCity] = "Edmonton" -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#3
|
|||
|
|||
new navigation control Access 2010beta
Hi Albert,
maybe it's because I didn't close the form while testing. I will give it a try tomorrow. There were no quotes in the property but thanks for the hint. Thanks again for your help, Lorenz |
#4
|
|||
|
|||
new navigation control Access 2010beta
....to all those who will read this later:
Yes, you have to close the form to let the 'Where...' property work. Even if you change the property. bye, Lorenz |
Thread Tools | |
Display Modes | |
|
|