Open subform to specific records based of off input from combo boxes (1 Viewer)

[mayestom]

Ha! Well I really appreciate you staying up to help me with this.

 

[Uncle Gizmo]

MDB is fine....

Posting it all is ok as long as I can find my way round it easy...

And you're fine with the data being public...

 

[mayestom]

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.

 

[Uncle Gizmo]

I've had enough excitement for one day. Will pick it up tomorrow.

If anyone else wants an interesting evening having a look at it, these are my notes so far and may be of interest:-

Form:- Program Customer ModelYear

Opens >>> Program Customer Model Year form
With >>> stLinkCriteria = "[Program]=" & "'" & Me![Program] & "'"

It Has a Subform
Packaging information charts - Copy Of subform

The subform has two controls that want parameters
The combobox:- cboICContainerCode Wants a parameter
Query1
[Forms]![Program Customer Model Year form]![Packaging information charts - Copy Of subform].[Form]![cboICContainerType]

The combobox:- cboOGContainerCode Wants parameter
Query2
[Forms]![Program Customer Model Year form]![Packaging information charts - Copy Of subform].[Form]![cboOGContainerType]


The form “Packaging information charts - Copy Of subform” has this SQL for it’s Recordsource which I have show with the exceedingly long table name Removed
'[Packaging information charts - Copy Of]. (48 fields?)

'SELECT [ID], [Record number], [Program],
'[Commodity / BU], [OEM], [Model_Year],
'[PKG_SPEC_#], [Part_Description], [P/N],
'[Status],
'[Highest_Level_Approval_by_Packaging_Spec], [Part_Weight_(lb)], [Bundle_Dimensions_(in)],
'[Circuit_Count], [Annual_Usage], [Daily_Usage],
'[Take_Rate], [IC_Type], [IC_Container_Code],
'[IC_Container_Dim], [IC_Dunnage], [IC_Std_Pack],
'[IC_Cnt/UL], [IC_UL_Std_Pack],
'[IC_Cont_Tare_Weight_(lb)], [IC_PKG_Gross_Weight_(lb)], [OG_Type],
'[OG_Dim], [OG_Std_Pack], [OG_Dunnage],
'[OG_Cont_Code], [OG_Cnt/UL], [OG_UL_Std_Pack],
'[OG_Cont_Tare_Weight_(lb)], [Affiliate], [OG_PKG_Gross_Weight_(lb)],
'[Region], [Border_Crossing], [DC1],
'[DC1_LOC], [Customer], [DC2],
'[DC2_LOC], [Customer_Location], [Part_#_in_PSO],
'[Returnable_Container_Procurement_Plan], [Production_Bundle_Approved_by_Customer],
'[Returnable_Containers_Delivered] FROM [Packaging information charts - Copy Of];

 

[mayestom]

Uncle Gizmo I totally understand and look forward to your reply tomorrow. Or anyone else's for that matter. Thank you.

 

[Uncle Gizmo]

I've had a look and these are my thoughts in a video:-

The video will be public for a day or so, after that I usually delete it. If you need it for some reason then I think you can download it.

http://youtu.be/XRKnjXbKrM0

 

[mayestom]

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?

 

[mayestom]

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.

 

[vbaInet]

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.

 

[RainLover]

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.

 

[vbaInet]

@Rain: I think we had the db in post #23 but it's been removed.

 

[RainLover]

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.

 

[vbaInet]

Uncle Tony is on it.

 

[mayestom]

vbaInet thank you for your reply.
I'm sorry, I'm not explaining myself very well.
They aren't supposed to be in both forms. One form (the switchboard) is used to open another based on values in combo boxes that aren't editable. They’re in a continuous format and which every record set is yours, you click on the button to open up the main form where you can input records in the subform. They are merely there as a very crude filter. And in the second form the values in the header aren't supposed to be changed. Only in the sub form of the second form are there to be records added. But that's neither here nor there. The present layout sort of works but it’s not what I want.
What I would like is to only have two search controls to be on a tab control on the main switchboard. Which in turn opens up another form to add records too. But I don't want the form to add records to be on the main switchboard.

 

[mayestom]

Rainlover:
I'm sorry I had it posted but decided to take it down because it had peoples names in it and didn't get there permission to post the db. I can repost if you would like for a little bit in order for you to look at it.
vbaInet and Rainlover sorry you guys are fast in your replies and I'm a little behind in my replies.

 

[RainLover]

Rainlover:
I'm sorry I had it posted but decided to take it down because it had peoples names in it and didn't get there permission to post the db. I can repost if you would like for a little bit in order for you to look at it.
vbaInet and Rainlover sorry you guys are fast in your replies and I'm a little behind in my replies.

I will let Tony follow up on this one. If he has problems then he can sing out.

 

[vbaInet]

And in the second form the values in the header aren't supposed to be changed.

Precisely the point that's being put across. If it's not supposed to be change it shouldn't be there in the first place or if you want to show what filters are currently being used, disabled those controls.

 

[vbaInet]

I will let Tony follow up on this one. If he has problems then he can sing out.

Over to Uncle T.

 

[mayestom]

vbaInet and RainLover: Thank you both for your input.
Thank you again for reading my post.
I will wait to see what Uncle Gizmo thinks I should do.

 

[RainLover]

Is this a case of looking for something upside down or back to front.