Forum Discussion
Should be easy...... Open a form to a specific record
I have a form with rows showing individual audit for staff members. Each audit would be individualized by an Autonumber ID field. I want the user to be able to click on the ID field, have it close t...
It can be helpful to incorporate fully qualified parameters in cases like this to avoid the problem of putting parameters in the wrong position.
Consider, for example:
DoCmd.OpenForm formName:="frmYourFormNameGoesHere", view:=acNormal, FilterName:="SavedFilterNameGoesHere", WhereCondition:="ID= " & LngValue, datamode:=acFormEdit, WindowMode:=acDialog, OpenArgs:=lngAnotherValueID