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

Select a Record from form and use that records source to open a form

P: 1
Hi Good Morning,

I am in position to solve a problem in MS access 2007.

Problem:
I have a Main form and contains subform. Based on combo selection the subform records are displayed. Main form and subform are using the same table. But, in subform there are mulitple records are displaying, based on user's selection in the subform, the record will be selected (Just three fields) and this records will be the source of opening other form.

Example:
Table x -
item code group pd loc
1 abc 10/12/12 NY
1 abc 11/12/12 AZ
1 abc 12/12/12 MD

If user wants to select record 2, what code/ procedure we can do?
How can we use this record as source to open a New subform?

Please help and your help will be highly appreciated.

Thanks!
Sep 26 '12 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
Welcome to BYTES!

You have two questions here... please only ask one question per thread.

Question 1:
If user wants to select record 2, what code/ procedure we can do?
What are you asking?
What can you do... you could call a function that calculates the root-mean-square to the 100th decimal place of the inherent error made by weighing out 1 mole of carbon atom by atom using a carbon nanotube resonator.

Question 2:
How can we use this record as source to open a New subform?
Yes.

Please decide which question to pursue in this thread and post the other in a new thread.
Sep 26 '12 #2

Post your reply

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