hi there, today the site is very

[vinanti]

hi there,

today the site is very slow,isn't it?
i had a lot of problems going through the kwyword search pages also,
anyways, does anyone there have a solution to my problem:
my code is:
i want to open the form based on 2 criteria i tried using and in place of & in the lnkcriteria but it wouldnot work even.

suppnm = Forms!mod_frm!supp_nm
compnm = Forms!mod_frm!comp_nm
lnkcriteria = ("[supplier name] = '" & Me![supp_nm] & "'" & "[company]='" & Me![comp_nm] & "'&quot
modvar = "modify"
If compnm = "All" Then
DoCmd.OpenForm "mast", acNormal, , "[supplier name] = '" & suppnm & "'", , , modvar
Else
DoCmd.OpenForm "mast", acNormal, , lnkcriteria, , , modvar
End If
DoCmd.Close acForm, "MOD_FRM", acSaveYes

plz help....

thnks in advance

bye ,
vinanti

 

[ToeShot]

this line is wrong
lnkcriteria = ("[supplier name] = '" & Me![supp_nm] & "'" & "[company]='" & Me![comp_nm] & "'&quot

try this
lnkcriteria = ("[supplier name] = '" & Me![supp_nm] & "'And" & "[company]='" & Me![comp_nm] & "'&quot

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait