Get data of combo box based on table on another subform (1 Viewer)

beti · Nov 22, 2019

Please help ...
I have a Mainform and 2 subforms. In one of subforms, I have a combox box which I would like to get data from a table of another subform. I did select the field I want from that table but it listed everything, how to do it to get only the data base on record selected.
I attached the sample database for ref …

theDBguy · Nov 22, 2019

Hi beti. I downloaded your file but not sure what to do with it. Can you please post a step-by-step instruction on how to duplicate your problem? Thanks.

Mark_ · Nov 22, 2019

Beti,
Is your second "form" limited based on a value in the parent? If so, you just need to update the criteria in your lookup to match. What gives me this idea is your "table of another subform". Tables themselves care nothing for what form/subform uses them. The criteria for a form/subform though does say which records from a given table you are looking for.

beti · Nov 23, 2019

theDBguy said:
Hi beti. I downloaded your file but not sure what to do with it. Can you please post a step-by-step instruction on how to duplicate your problem? Thanks.

theDBguy,
Thanks for checked it out. Here's the situation:
I have mainform which is 'Software'. I have 2 subforms 'software_version' and 'version_checkout'.
The DB relationship is a software can have one or many versions and each version can be check out by one or many people ...
For example if you look at first record, I have AcrobatPro and Version Pro 11 and Pro 12. I have subform
'version_checkout' which let people select with in the list of software version above.
In the Software Version Checkout subform I created a combo box 'version checkout' and I would like to get the
list of version above (Pro 11 and Pro 12) for people to select of version to check out. Right now I selected
the table and got data of all records. Such as I would like record 1 only 'Pro 11 and Pro 12' and record 2 only
'Access 1 and Access 2'
Thank you for your help.

theDBguy · Nov 23, 2019

beti said:
theDBguy,
Thanks for checked it out. Here's the situation:
I have mainform which is 'Software'. I have 2 subforms 'software_version' and 'version_checkout'.
The DB relationship is a software can have one or many versions and each version can be check out by one or many people ...
For example if you look at first record, I have AcrobatPro and Version Pro 11 and Pro 12. I have subform
'version_checkout' which let people select with in the list of software version above.
In the Software Version Checkout subform I created a combo box 'version checkout' and I would like to get the
list of version above (Pro 11 and Pro 12) for people to select of version to check out. Right now I selected
the table and got data of all records. Such as I would like record 1 only 'Pro 11 and Pro 12' and record 2 only
'Access 1 and Access 2'
Thank you for your help.

Hi. Thanks for the explanation. See if this is what you wanted.

vba_php · Nov 23, 2019

beti,

I still think, based on what you posted earlier: https://www.access-programmers.co.uk/forums/showthread.php?t=307979, that you're going about ur project the wrong way. I think ull run into problem down the road the way ur going. I still think what you wanted here can be done without code, but I did it a different way if you want a peek, with a button which can be modified to give the user a confirmation that they've checked out a piece of software.

beti · Nov 24, 2019

theDBguy said:
Hi. Thanks for the explanation. See if this is what you wanted.

Hi the DBguy,
Thank you very much, this is exactly what I want. But I do have question … If I add more Version of of Software Version List (such as Pro 13, Pro 14 ..)
Then I support to see these new added when I click on the combo box of 'Version Checkout' but I don't see it unless I click on the next record and click back then I can see them. Is there a way I can see it right away in 'Version Checkout' drop down list?

beti · Nov 24, 2019

vba_php said:
beti,

I still think, based on what you posted earlier: https://www.access-programmers.co.uk/forums/showthread.php?t=307979, that you're going about ur project the wrong way. I think ull run into problem down the road the way ur going. I still think what you wanted here can be done without code, but I did it a different way if you want a peek, with a button which can be modified to give the user a confirmation that they've checked out a piece of software.

Thank you for making it in different way, it's cool.

vba_php · Nov 24, 2019

beti said:
Thank you for making it in different way, it's cool.

either way you go about it, uve got it done, so great!

theDBguy · Nov 24, 2019

beti said:
Hi the DBguy,
Thank you very much, this is exactly what I want. But I do have question … If I add more Version of of Software Version List (such as Pro 13, Pro 14 ..)
Then I support to see these new added when I click on the combo box of 'Version Checkout' but I don't see it unless I click on the next record and click back then I can see them. Is there a way I can see it right away in 'Version Checkout' drop down list?

Sure. Here you go...

beti · Nov 24, 2019

theDBguy said:
Sure. Here you go...

Got it, thank you very much, appreciate all your help!

theDBguy · Nov 25, 2019

beti said:
Got it, thank you very much, appreciate all your help!

Hi. You're welcome. We're all happy to assist. Good luck with your project.

Get data of combo box based on table on another subform (1 Viewer)

beti

Registered User.

Attachments

theDBguy

I’m here to help

Mark_

Longboard on the internet

beti

Registered User.

theDBguy

I’m here to help

Attachments

vba_php

Forum Troll

Attachments

beti

Registered User.

beti

Registered User.

vba_php

Forum Troll

theDBguy

I’m here to help

Attachments

beti

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread