MS Access: how to select a record by ID?

Question

Hello Dear ,

kindly i need your assist on how i can get the record by ID  in form.

Thanks in advance.

Regards,

Hassan

Answer 1

Typically, one would open the Details form from the double-click event of the List form.

Design the list form, then find the double-click event in the Properties window, click the … button and enter this VBA one-liner:

docmd.OpenForm "Functions",acNormal, ,"ID=" & Me.ID

(I'm guessing at your object names; change as needed)

Answer 2

Hi Hassan,

To better assist you, we would like to collect information about your situation. Could you please help provide some steps and related screenshots about how you create a database and the form there, so that we can test with full information on our side? Do you mean Form type below? 

Thanks,

Tina

Answer 3

Use Ctrl+f on your keyboard to open a search form.

Answer 4

Dear Tina ,

I want to select for example ID 4 , so in the form the data for record 4 will be appeared and by clicked on the button Edit i can edit this record .

see in the above screenshot , once i selected ID 4 ,the record down still in 1 .i need automatically go to record 4

Answer 5

Dear Peter,

I want to select for example ID 4 , so in the form the data for record 4 will be appeared and by clicked on the button Edit i can edit this record .

see in the above screenshot , once i selected ID 4 ,the record down still in 1 .i need automatically go to record 4