Subform

[dj_tigger1982]

Ok this question might be a bit hard to follow or understand. I hope I can explain this correctly.

I have a query which I have created which displays all the open calls that are on my database.

I want to create a subform in a form that displays all of the information that the Query gathers. However what I want to be able to do is to double click on the infomation in the subform and for it to display it in a sererate window.

This was done at my previous job but I never created the DB so I did not know how to do it, and I jst wondered if It was easy to do.

I prolly made no sence


Mike

 

[ColinEssex]

Use a ListBox to do this not a subform. The wizard will create it for you.

Col

 

[dj_tigger1982]

OK I got it to show it on the list box and it looks liek how I want it to look.

How do I now get it to double click and open up the records in a serperate window? Do I need to set up an action to happen? If so how do I get it to preform that action?

Mike

 

[Rich]

Use the Command Button wizard to create a button and code, copy the code to the double click event of your listbox. Delete the original code and button

 

[dj_tigger1982]

OK thank you for that. I now have my list automatically openin the form. However it is opening the form in add mode and and there is no data in the form. How do I set it up to open the form with the data that I select from the list?

Sorry about this I am a complete novice at this thing

Mike