Filtering a form

[George]

Good Day all,

My form "Applications" have a lot of records. One of its fields is [Programs/Course]. I add a combo field [Combo1] which collects it list of values from somewhere. I would like to change the record displayed in the form to a record based on the value clicked on in [Combo1]. ! am trying to use an embedded macro.

I do not know what to enter for the filter name. And the where condition I entered is as follows: [Programs/Course]=[Combo9]


Does anyone have the answer?

[June7]

See if this helps http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

The name of the control should be fully qualified, for example:Forms!formname!controlname