Openform Statement???

[vinanti]

hi guys,

Thnks for the help i have always been provided on time.

I am again stuck up badly.

I have to open a form from another form.
I want to pass an argument --- compulsory and at the same time show records only of the supplier name provided by the user.
I am using the foll statemnet:
DoCmd.OpenForm "mast", acNormal, , "[supplier name] =Forms!mod_frm!supp_nm" , , , modvar
This works fine.
but i face a problem when i try to replace forms!mod-frm!supp_nm with a variable=supp.

It is a very essential thing for my program as i want to further add features to it.

Plz. help

thnks in advance
bye,
vinanti

 

[SgtJarrow]

I believe it should read:

DoCmd.OpenForm "mast", acNormal, , "[supplier name] = '" & & supp & "'", , , modvar

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com