form filter help

[Lez]

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

 

[Golfinray]

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

 

[Lez]

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
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,

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