Open selected record - access2016

[akika]

hi,


Pls help
In access 2016, i have one main table (tbl_employee)
and create 3 different forms based and uses that main table fields.
form1RW : all fields are in read-write
form2RWRO : some fields in readonly and some in read-write
form3RO : all fields in read-only


I've created another form4ListAll in continuous and which display show records under certain criteria.
With a button (btn_openRec) on that form4 which when click will open the selected record.




Embedded Macros:


OpenForm
Form Name
View Form
FilterName
where condition == '[ID] ="&[ID]
Window mode Normal


Issue is that when i click on the "Open Record' Button its opening a blank form - the data for that record is not appearing in the being called form.

[isladogs]

Not an answer to your question but I suggest you replace the embedded macro with vba.

Why on earth do you have three different forms?
If the idea is related to the permission levels of different users, you only need one form and set different conditions based on the logged in user.
Maintaining multiple forms is both unnecessary and will massively increase your workload as a developer.

[akika]

do u have an example for the vba ?
onclick event procedure and what piece of codes are to be added pls?

On form load hve:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub