Xenix Registered User. Local time Today, 00:45 Joined Oct 8, 2001 Messages 124 Jan 29, 2002 #1 I would like to filter fields in a record that are left blank, how can I make this command do this: Me.Filter = "TotEmployees = ' '" seems not to work for me thank you in advance Mike
I would like to filter fields in a record that are left blank, how can I make this command do this: Me.Filter = "TotEmployees = ' '" seems not to work for me thank you in advance Mike
David R I know a few things... Local time Yesterday, 18:45 Joined Oct 23, 2001 Messages 2,632 Jan 30, 2002 #2 Me.Filter I believe refers to a saved filter. Look into using the WHERE clause and the IsNull function. HTH, David R
Me.Filter I believe refers to a saved filter. Look into using the WHERE clause and the IsNull function. HTH, David R
