Question Syntax for applying filter to navigation button (1 Viewer)

[byTimber]

I am going crazy with this;

I have a navigation form containing several forms. The forms are set to a table and the controls are set to the appropriate fields.

I need to filter the data to the forms (in the navigation pane to field "BusinessName" passed as the variable lvrName)

I have ;
"[BusinessName] = " & Chr(34) & lvrName & Chr(34)

doesn't work.
Can any psychiatrists / super helpers put me right!
Please!!

 

[Isskint]

If you are just wanting to set the forms filter then use:

Me.Filter = "([BusinessName] = '" & lvrName & "')" Note the use of a single quote mark after the = sign and before the close bracket )
Me.FilterOn=TRUE

 

[byTimber]

Thanks IsSkint - The very answer I needed. You should get an award!!!! R ....