add button to filter data on form

  • Thread starter Thread starter Smoki
  • Start date Start date
S

Smoki

Hi,
I have a form which shows most of the fields from my table (it's a form
which shows equipment in several places). But I want to add button (command
button) and when i click on it, I want to see equipment which I have in only
one place!
I put a command button Apply Form Filter, and in Form properties in Filter I
put: Location==49 (because 49 is Location_Id in Location table).
But it doesn't work. I have an error: The expression On Click you entered as
the event property setting produced the following error: Type mismatch!!!
Help???
 
What's the actual code you placed for the button's Click event? What's the
data type of Location_Id: is a Text field, or a numeric one?
 
That was a problem, thanks. I had to check Location, and that is a text
field, and I always put in filter Location_Id, which is numeric field.
I solve it now, thank you!

Smoki
 
Back
Top