form filter help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lez - 07 May 2008 16:36 GMT

Hi Guys,

Can anyone tell me why this will not work?

[Forms]![frmReferals]![txtReferalID]

I have a form that I want filter by the value of txtReferalID for some
reason this does not pick it up?

Any suggestions

--------------------
Access 2007

Reply to this Message

Golfinray - 07 May 2008 20:54 GMT

It is easier to just use a combo box. Use the wizard to set the recordsource
of the combo to txtreferalid. Then go into the properties of the combo, find
events, go to afterupdate and click on code builder. Type:
Me.filter = "[txtreferalid] = """ & Me.yourcomboandcombo# & """"
Me.filteron = true

> Hi Guys,
>
[quoted text clipped - 9 lines]
> --------------------
> Access 2007

Reply to this Message

Lez - 12 May 2008 17:55 GMT

Hi,

Thanks for that, however, I do not understand your method?

The txtreferalID will not have a value until a choice is made from the combo
box?

> It is easier to just use a combo box. Use the wizard to set the
> recordsource
[quoted text clipped - 17 lines]
>> --------------------
>> Access 2007

Reply to this Message