|
| 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
November 1st, 2006, 11:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
filter a form on open ?
good day,
i'm trying to open a form and filter the records based on a check box upon opening the form... I know this should be easy, but my mind has run blank.. Can anyone help me? Thanks, 
|
|
#2
November 2nd, 2006, 12:01 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
filter a form on open ?
Hi Brook,
If it's based on a check box, you might want to consider using an On Current event (if the check box will change each time the record changes)... Either way, the code is the same... Either in the On Current or On Open event (depending on which one is appropriate for you) put: me.filter = FILTER me.filteron = true where FILTER is the filter you require, eg: "[Surname] like '*smith*'" Damian. "Brook" wrote: good day, i'm trying to open a form and filter the records based on a check box upon opening the form... I know this should be easy, but my mind has run blank.. Can anyone help me? Thanks,
|
|
#3
November 2nd, 2006, 12:17 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
filter a form on open ?
Hello...
thank you... That is what I was looking for! Brook "Damian S" wrote: Hi Brook, If it's based on a check box, you might want to consider using an On Current event (if the check box will change each time the record changes)... Either way, the code is the same... Either in the On Current or On Open event (depending on which one is appropriate for you) put: me.filter = FILTER me.filteron = true where FILTER is the filter you require, eg: "[Surname] like '*smith*'" Damian. "Brook" wrote: good day, i'm trying to open a form and filter the records based on a check box upon opening the form... I know this should be easy, but my mind has run blank.. Can anyone help me? Thanks,
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
