form filter help

  • Thread starter Thread starter Lez
  • Start date Start date
L

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

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?




Golfinray said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top