Displaying data

[helpmeplease213]

Hello,

Is it possible to have a subfrom in a main table that displays all data that has been entered into the table, when you double click on a particular row a form pops up and displays the data in a pre-determined structure.

So I guess my main question is whether it was possible to have a form pop up when you click on a row in either a table or a query.

Thanks

[Rabbit]

Hello,

Is it possible to have a subfrom in a main table that displays all data that has been entered into the table, when you double click on a particular row a form pops up and displays the data in a pre-determined structure.

So I guess my main question is whether it was possible to have a form pop up when you click on a row in either a table or a query.

Thanks

You can't do it from a table or a query. You can do it from a form though.

[helpmeplease213]

So you can do it from a form. Can you point me in the right direction or give me a overview of how to do it?

Thanks

[Rabbit]

Well, in the Double-Click event of your choice you just have it open a form with the appropriate filter criteria.

[helpmeplease213]

Hello,

I don't quite understand how to go about achieving this. I can get the form I want to popup on the double click event but I don't know how then to assign the data from that row of the form into the popup form. Any help is appreciated.

thanks

[Rabbit]

You wouldn't be assigning any data. You'd use the Filter parameter of DoCmd.OpenForm to filter the records using a unique identifier.