Re: Filter by selection
- From: "Graham Mandeno" <Graham.Mandeno@xxxxxxxxxxxxx>
- Date: Thu, 13 Apr 2006 22:47:52 +1200
Hi Chey
If TA Number is a numeric field:
Me.Filter = "[TA Number]=" & Me![TA Number]
Me.FilterOn = True
and if it's a text field
Me.Filter = "[TA Number]='" & Me![TA Number] & "'"
Me.FilterOn = True
Note that the [TA Number] after Me! is the name of the control (textbox),
which could be different from the name of the field.
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
"Chey" <Chey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C76F4639-F2A5-4ECA-AF36-15A4DB90A20A@xxxxxxxxxxxxxxxx
I have the focus on a field. What is the code to filter by selection.
my field name is Travel Request.TA Number.
Thanks
.
- Prev by Date: Re: refresh sub form
- Next by Date: Prevent overlapping times being entered
- Previous by thread: Listview with Item 'Stuck' in it
- Next by thread: Prevent overlapping times being entered
- Index(es):
Relevant Pages
|
