Using Filter within a Form (VBA) 1

[Harlequin007]

Morning everyone

I've developed a form which is tied to a table and I want to use a filter on a particular field. However, the properties dialog does not appear to have an option to do this.

Can it be done using VBA...?

e.g. field x = Design Actionee and I only want to display records on this particular form where Design Actionee "Is Not Null"

Any thoughts...?

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[RoyVidar]

Hi!

There is an option for filter in the properties dialog, but I must confess to nevere have used it.

I'd either use the filter in the underlying recordset (query) or:

[tt]Me.Filter = "not [Design Actionee] is null"
Me.FilnterOn = True[/tt]

Roy-Vidar

 

[Harlequin007]

That's fine Roy.

Worked a treat.

I wasn't using the brackets.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------