Form Filter Event.......

A

AFKAFB

Hi

I've a form bound to a table. When I open the form I want it to
filter on a field [RWA] = "XYZ".

How do I do this?

Regards

AFKAFB
 
A

AFKAFB

ok
if the form is built off a table say 'tbl_sustomers'
where would i put this on the event
chris
 
R

Rick B

You would go into the form's properties box and find the "data source".
Click the ellipse to the right to initiate the query builder, and modify it
there. This will save the new criteria in the report as a query.
 
A

AFKAFB

Rick
I've done as suggested in the 'Record Source' Property and this reduces
the number of records.
However, this seems to be confleciting with the Form Current command
and is giving me a runtime error '2424'
with the message
'The expression you entered has a field, control or property name that
Access cannot find'.
Any ideas
chris
 
Top