Form Event Procedure

[Jgk]

Form =frmMenu


Field of Form = txtuser
filter to go to record on load event
Form = frmContractor
Find Record or Field = Login

I am trying to get it to go to find a specific record on form

Here is the on load Event Procedure I get syntax error
Private Sub Form_Load()
Open the form
DoCmd.OpenForm "frmContractor", acNormal, , sWHERE Login = Environ("username")
End Sub

Thanks

[Bob Fitz]

DoCmd.OpenForm "frmContractor", acNormal, , sWHERE Login = Environ("username")

What is "Login" and what is "sWHERE"

[Jgk]

login = username on frmMenu and is on frmContractor
swhere I was trying that I found on this forum. Really not sure why it is not just where login = Environ("username")

[Bob Fitz]

What happens with just WHERE

[Jgk]

compile error expected:end of statement error syntax error

[Bob Fitz]

Perhaps something like:
DoCmd.OpenForm "frmContractor", acNormal, , "Login = '" & Environ("username") & "'"

[Jgk]

Thank you it works

[June7]

Bob's suggestion is valid syntax.

sWHERE was probably a variable that was populated by code in whatever example you were following. Also demonstrated in http://allenbrowne.com/ser-62code.html which you might find useful for more complex filtering requirements.