access 2016 , open existing record from another form when click hyperlink

[akika]

hi


pls help

I have a form in columnar list format
ID, EmployeeID, Name, Address, Phone

The ID and Employee ID has a hyperlink, which when click upon should open the form "employee detail".

Which vba procedure should be used to do this action?


I've tried but not ok
docmd.openform "employee_detail", acFormDS, "EmployeeID"

[June7]

WHERE CONDITION is incomplete. You need a parameter, such as reference to a control or field on form:

DoCmd.OpenForm "employee_detail", acFormDS, "EmployeeID=" & Me!EmployeeID

[akika]

Thxs one more query plz.
How can open another form from an existing form using the employee ID.
from the form list of employee when click ID open form employee_detail specific record.

When adding the code.. its not opening the specific record but the first record in the table.
for e.g ID 1234 should open form employee with ID 1234 but am getting 1000 which is the first record in the table

[Welshgasman]

Show your code.
Put the criteria into a string variable and then use a debug.print to see what the criteria is.

[akika]

it working now thxs