Open subform to specific records based of off input from combo boxes

M

mayestom

Registered User.
Local time
Today, 04:19
Joined
Jul 7, 2014
Messages
213
I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done?
Thank you.
Using:
Win 7
Access 2010
 
Yes, it's a subform created by subform/subreport control and placed in the detail section of another form.
 
Sorry for the cross post. I did not know. This is the original post.
 
Again sorry for cross posting. This is the original post and this is a link to the cross post.
And Uncle Gizmo I forgot to thank you for replying to my post.

Okay. The Switchboard is a separate form. And the subform is in datasheet view.
I've attached screenshots to help explain better.
Right now on the switchboard you will eventually have to scroll through many records to get to the record you want and click the "open form" button to open the form with the subform filtered to those records. What I want to do is get rid of all list of records on the switchboard and just have to combo boxes (Customer and PKGEngineer) and a "open form" button to open the form with the subform to those records. Am I explaining this properly?
 

Attachments

  • Switchboard.PNG
    Switchboard.PNG
    37.7 KB · Views: 315
  • main form with subform.PNG
    main form with subform.PNG
    66.7 KB · Views: 227
Yes...if I'm understanding you correctly. So on the Switchboard you would select from two combo boxes and they would correspond to the combo’s on the form with the subform. Sorry if I’m repeating myself, just want to make sure I’m explaining this properly.
 
Sorry took to long to respond to your other post and didn't see post #11. Never thought of all combos empty. One or both should always be selected or there is use going to the other form. But I guess if they are left empty then all record would be shown.
 
The more I think about it, both combo's should not be left empty. They whole point of doing this is to filter the records to only show the one's selected by one or both combos.
 
When the "Program Customer Model Year form" (sorry for horrible naming convention) is opened from the navigation pane, it opens to the first record from that table "Program Customer ModelYear". And the subform displays all records associated with those combos (with Program, Customer and Model Year being the links). The records that populate the subform come from another table.
But to answer your second question: Yes I would like to only have Customer and/or PKGEngineer pass values to the Program Customer ModelYear form. Would it be easier for me to post the db?
 
Again, I’m too slow on my response. You are really fast!
Okay so replying to two post:
Post #16 reply:
Right now the way I have it set up, with the different tabs for different car lines is not the way it will be once I have it with just the two combos. I have it set up that way bc I was originally thinking that was a way I was going to filter. But instead I think using the two combo boxes, Customer and PKGEngineer is a better, cleaner way. So please disregard the tabs with all the car lines in them. Once I have it set up with just the two combos I will do away with all the tabs for the different customers bc that’s what the combos will represent.
Post #18 reply:
The db is in .mdb format. I think 2002-2003 file format. Will that work? Also, I’m not sure how to make a mock up? How do I post just the relevant forms and not the whole db?
 
Ha! Well I really appreciate you staying up to help me with this.
 
Okay, I've attached the db. Open form "Switchboard" (again I'd do away with all the subtabs and just leave the "carline" and "general forms" tab)that's where I'd want the two combos of Customer and PKGEngineer and a button to open the other form to the filtered records selected from the two combos. The form to be opened is called "Program Customer Model year form". So really the way it's set up on the switchboard is kind of the way I would ultimately set up but with just the two combos and the button to open form.
 
Last edited:
Uncle Gizmo I totally understand and look forward to your reply tomorrow. Or anyone else's for that matter. Thank you.
 
Thank you for the video. I was only able to look at it once (I'm at work at the moment). From what I'm understanding is that you think I should only have one form? If so, I didn't understand how the user will be able to filter to records that only pertain to them?
 
Uncle Gizmo, thank you for your time and effort and trying to sort out my problem. I very much appreciate it.
I guess I need to redesign my two forms. Not entirely sure how but will try and figure it out.
Thank you again.
 
What Uncle Gizmo is telling you is that it's only logical to have the controls used for searching in one of the forms not both.
 
Did we get a Pic of the Relationships or did I miss that.

I must add that I have never seen this approach before.

I thought we were getting a copy of the database.

Uncle Gizmo wants his in 2007 and I would prefer 2003.

Can you do both please.
 
@Rain: I think we had the db in post #23 but it's been removed.
 
vba

I can't understand what the problem is let alone the solution. I will leave it alone until things are made clear.

I did look at the naming of various objects. I stopped half way through as it was giving me a headache.

It is bye from me for now.
 
You must log in or register to reply here.

Similar threads

S
Solved Need help querying subform's combo box based on the main form.
Replies
13
Views
1,256
SkeletorPlus
S
F
Open multiple instances of subform
Replies
7
Views
822
MajP
MajP
G
Strange behaviour from a combo box on a form when trying to evaluate data in another column
Replies
6
Views
678
GPGeorge
GPGeorge
A
Search box to find parts to add to job instead of a combo box
2 3
Replies
40
Views
2,367
Gasman
Gasman
H
Solved Method of selecting specific records
2
Replies
20
Views
1,415
Harris@Z
H

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom