I feel stupid asking this but I need a VBA code. I have a continous form, a list basically. When you click on any record, say record 10 with an ID of ABC, I want it to open another form displaying a single record which should be the same record (ID of ABC).

What I described is from same database and same table.

Assuming both forms currently exist, use the Button wizard for "Open Form in Edit", you will need to identify the form you want to open and then the link between the forms and... it will give you the code you need. Then transfer the code to your listbox click event, and delete the button that you don't need anymore. Once you have done it once... you will get the hang of it.

Thanks for the response. What you have done for me is opened up lots more possibilities.

I am new to Access and VBA but I am excited so there is energy to pursue things.

That's why I didnt just give you the code to do it. ;P