DoCmd.GoToRecord

[Mtyetti2]

I have an employee database which has a login form. A query returns the value of the last employee logged in. I use this to restrict edits/features on various form 'onopen'.


I have a basic Employee Form. I'd like to that form to only open to the record of the current employee who is logged in. In other words, open the form and go to the record where the LogIn employee value matches the Employee ID.

I'm looking for the docmd.gotorecord code, not a macro.

Thanks for the help!

[ItsMe]

You probably want to use DoCmd.OpenForm. With this, you can apply a where condition to the open event that will affect the recordsource of the form vs. only navigation to a record within a recordset.

DoCmd.OpenForm "frmMyForm", , , "[EmployeeID]= glngEmployeeID"

Here, this code assumes that there is a global variable that holds the value of the EmployeeID.

[June7]

Except do not include the variable within quotes, concatenate variables.

DoCmd.OpenForm "frmMyForm", , , "[EmployeeID]=" & glngEmployeeID

[ItsMe]

Thanks for catching that June