Combo Form Filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lez - 06 May 2008 12:18 GMT

Hi Guys,

I have a combo and text box on a form, the text box holds the value of the
combo on the 'after update' event.

I want the form data to filter by the text box value but cannot get the
filter to work.

I have used the 'build wizard' to target the text box (txtrefereID) and get
this path info:

Forms![frmReferals]![txtReferalID]

However, this does not filter the form data, can anyone help me with this?

Many thanks

Reply to this Message

Golfinray - 06 May 2008 13:32 GMT

Use a combo to hold your selections that you want the user to choose from on
the form. In the afterupdate event code put:
Me.Filter = "yourfieldname = """ & Me.Combo & """"
M.Filteron = True.
Use the combo wizard to select the field name for you and then plug in the
number of your combo box. This filter will work on almost any form.

> Hi Guys,
>
[quoted text clipped - 12 lines]
>
> Many thanks

Reply to this Message

Lez - 06 May 2008 17:35 GMT

Many thanks for the reply, however, I do not understand your reply? I can
already populate the txtbox with the value I want, I just need to filter the
form data now by the value of that field.

This is were my problem is, not getting the combo value, filtering the form
data with this value

Any other suggestions, appreciated.

> Use a combo to hold your selections that you want the user to choose from
> on
[quoted text clipped - 23 lines]
>>
>> Many thanks

Reply to this Message