By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Displaying data

P: 20
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
Dec 17 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,365
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.
Dec 17 '07 #2

P: 20
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
Dec 18 '07 #3

Rabbit
Expert Mod 10K+
P: 12,365
Well, in the Double-Click event of your choice you just have it open a form with the appropriate filter criteria.
Dec 18 '07 #4

P: 20
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
Dec 20 '07 #5

Rabbit
Expert Mod 10K+
P: 12,365
You wouldn't be assigning any data. You'd use the Filter parameter of DoCmd.OpenForm to filter the records using a unique identifier.
Dec 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.