open form with where condition from a variable

[Lightlancer]

Hi,

I want to open a form with a macro, in that form there is a field named: "NaamMedewerker"

Stored in a variable "gstrDezeMedewerker"

now the form must open on the right record, so the where condition must be something like

NaamMedewerker = gstrDezeMedewerker

i Tried this:

="NaamMedewerker=" & ( & gstrDezeMedewerker & )

but that isnt right

any ideas?

 

[JBinQLD]

gday light,

i think this is pretty well documented in the help file? i dont use macros but i think your example should be

="NaamMedewerker= '" & gstrDezeMedewerker & "'")

if both are strings, or

="NaamMedewerker= " & gstrDezeMedewerker)

if number.

Don't forget the cstr, val or cint/clng etc functions if you're using a mix

JB