CODEWITHSUNDEEP
ms-accessvba
user229342
user229342

Reputation: 3

Access VBA open form on current record

I have a form in loading records in continuous mode that looks like a datasheet. I want to have a button at the beginning of each row of data that I can click on the will open up a form for users to edit.

So far I got the edit form to load by using DoCmd.OpenForm

This loads the first record no matter which record's button I click on. I tried the DoCmd.Gotorecord and this does not work. How can I fix this>?

Upvotes: 0

Views: 1966

Answers (1)

AVG
AVG

Reputation: 1462

DoCmd.OpenForm "YourFormName", acNormal, , "YourUniqueID=" & Me!YourUniqueID

Upvotes: 2

Related Questions