Search results

Okay I've attached the most recent copy. The form is called "Program Customer Model Year form". In the subform the main combo box is called IC_Type the dependent combo box is called IC_Container_Code and the text box is called IC_Container_Dim I know how crazy the whole thing looks but that...

You're correct, I don't want that. I should only have those three options (EXP, RET and SEQ).

Not sure what you mean? I am grouping in the first combo box. This is the statement for the first combo box: SELECT ContainerType.Container_Type, ContainerType.Container_Dimensions FROM ContainerType GROUP BY ContainerType.Container_Type, ContainerType.Container_Dimensions; Which I...

When I try to add the fields that I want, they get Grouped by as well and the first combo box gets screwed up. By that I mean the selection is not grouped by it just lists all the fields in that table. So instead of three options (EXP, RET, SEQ) I get 83, which is the total number of records...

Yes, you're right. Trying to do to much at one time. My brain is starting to melt. I'm lossing track of what to do :confused: The Row Source of the first combo only has one field that it's grouped by, the Row Source for the second combo is empty. Would I add the fields I need to the Row...

I wouldn't make a selection for the other five fields. They would be filled in as a result of the selection from the second combo box.

Great, but now I need to get the other five fields to fill in once I choose a selection from the second combo box. Would those be text boxes with a Control Source = to the selection of the second combo boxes column that I need? ex: =[cboICContainerCode].[column](1)

You're right. Okay, a little back ground: I have an Excel spreadsheet that uses vlookup's. So when you select an option in one cell the selection in the next cell changes based on the first cell. Then when you select the option in the second cell, values in five other cells are automatically...

Now I'm trying to emulate the second example from the link you sent: http://www.fontstuff.com/access/acctut10.htm because I have a single table that provides the data for the Row Source for both combo boxes. tick tock, tick tock and a little :banghead: later... AH HA! I did it! By following...

I've added the combo boxes and added the code to them. But when ever I select an option in the first combo box it takes me to the front of the table. And the cascading combo box is not registering anything. And it's made the subform not register a record in the respective table. If you...

I understand but the form name is CascadingComboSample and the table name is Cities. I guess I should do some more reading.

He has two ways of doing it and I'm not sure which way to emulate. (And it was erroneous of me saying it was simple. Sorry pbaldy if you are reading this). He states: "One is to have the row source of the second combo refer to the first in its criteria, then requery the second combo in the...

Hi Gina! Thank you for replying to my post. Yes, Cascading Combos (didn't know the name of it) is what I think I am looking for and I think I found an example of it from an example db that a user named pbaldy used to answer a post with a similar question on this forum. The example he has is a...

I know I have seen this asked before or a variation of it, but the poster had already known where to start and had some structure in the form. But the difference with me is that I don’t know where to begin. With that said… In my subform, I have a field named Container Type (I know you don’t...

Gina I don't know how to thank you. I don't know what I would have done if you didn't help me with this. You are amazing! Thank you for everything you have done for me. For all your time and effort and answering my basic, and sometimes stupid questions. I really appreciate it. I learned a...

That worked! Deleted Supplier Name and added Supplier Name in it's place. Which doesn't make sense to me? I'm deleting Supplier Name and adding Supplier Name :confused: They're both the same thing. Why would one work and not the other? But also I or a user would need to do that every time...

Here is the SQL for the Record Source of the Report: SELECT Equipment_Spec.Picture, Equipment.Unit_Cost, Equipment.Quantity_Purchase, [Unit_Cost]*[Quantity_Purchase] AS Total, Equipment.Project_Name, Equipment.Supplier_Name, Equipment.[Location/Affiliate_Name], Equipment_Spec.Description FROM...

Saved the form but no to Module. Changed the column count to 2 but still no name.

That did it! It works fine, can filter on Supplier or Equipment or both or neither. And the Supplier name even comes through on a Report! I still need to figure out why the name does not show up on a filtered Report on the other form (frmMultiSelectqry). I changed the Column Count to 1 and...

Okay changed that. Now when I select a Supplier and push Set Filter nothing shows. Even if I pick the Supplier that I know is in the table. But when I select an Equipment the query works.