server filter

[Diavolo]

Hello, how can i set server filter on loading form? I use

Me.ServerFilter = "Bylos_nr = '&[Forms]![teise]![Bylos_nr]&'"
Me.Refresh

But recyve error : invalid sql statement

sorry for my english...

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Incorrect syntax. If Bylos_nr data type is a string:

Me.ServerFilter = "Bylos_nr = '" & [Forms]![teise]![Bylos_nr] & "'"

If Bylos_nr data type is numeric the string should look like this:

Me.ServerFilter = "Bylos_nr = " & [Forms]![teise]![Bylos_nr]

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDZYCIechKqOuFEgEQKfcgCfRJ9iwhXjZCEYMS2IaOLfwttxdF4AoPzx
AGODLprdBScB5gGBRsHVk/92
=BY/b
-----END PGP SIGNATURE-----

 

[Diavolo]

Incorrect syntax. If Bylos_nr data type is a string:

> Me.ServerFilter = "Bylos_nr = '" & [Forms]![teise]![Bylos_nr] & "'"

thanx It works