var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: docmd.applyfilter simple problem
Okay so im trying to do a docmd.applyfilter so that the data within a form is filtered based on a particular value
one field is "RFC" and the following code works
DoCmd.ApplyFilter , "RFC = '" & searchValue & "'"
However, whenever a field has a space in it, it produces an error message as before the space it expects the '=' operator.
DoCmd.ApplyFilter , "Hardware Model = '" & searchValue & "'"
DOES NOT WORK as after 'Hardware' it wants '=' not a space(' ').
How do i get round this problem? I have tried searching Hardware_Model and it prompts me to enter in a value and doesn't work.
any help would be greatly appreciated
THANKS IN ADVANCE
DoCmd.ApplyFilter , "[Hardware Model] = '" & searchValue & "'"
Have a nice day!