Search results

Is there a particular time you are online? You have been such great help that I'd like to be able to ask you questions when I run into them.

I had to fix the order by and now it works. :) Now hopefully I can get it to run from the form. :)

I put the code for the fourth combo box in the after update of the 3rd combo box. The parameter asks for the name of the group chosen in the 3rd combo box. Then it populates with the right choices.

The third box is now feeding the fourth but only after it pops up a parameter box when I make a choice from the third box, when I choose it populates the fourth one withe appropriate choices. What do you suggest I look at?

I have to go offline for about 4 hours but I will be back so please stick with me on this. I really appreciate all you are doing.

Please go ahead and start from cbo 2. That is the one that lists Line 1 or Line 2. It feeds to the list in cbo 3.

The first combo box will be changed to a Calender to enter a date. What kind of query am I looking at and where would it go? Now I am confused about where to start?

I thought it was attached. Trying again. Can you please email the thing back to my email when you are done looking at it or do you just want to post it?

Ok I have recreated a stripped down version of the DB showing this subform. I is used to report downtime for two lines and the users just want to pick from a list that becomes loaded from a previous choice, those choices are done through a comboBox list.

I was hoping i was writing a query that would use the line1 or line2 selection to populate the 3rd combo box. When I take the line before the requery out I get a data type mismatch or criteria error message when I select the line I want and then click on the down arrow on the 3rd combo box on...

This is the code I am trying to use: Private Sub ComboBox2_AfterUpdate() Me.ComboBox3.RowSource = "Select MachCenterName FROM" & _ " tblMachCenter WHERE LineId= " & Me.ComboBox2 & _ " ORDER BY MachCenterName " Me.tblMachCenter = Me.tblLine.ItemData(0) Me.ComboBox2.Requery End...

I haven't tried it yet but I will in a little while. Please keep checking back later so I can ask more questions. I have been trying to get this to work since about 6:30 this morning so I think I need to walk away and regather. Thank you for your help. When I do requery how would I write it...

That is one of the examples I have been working with and for some reason I can not get it to work with what it is I am doing. I have set the code to the naming conventions I am using so that it basically duplicates what I am seeing and I am still missing something. I really need help in...

I need some real help. I a working on a subform that a user wants for easier data entry. On it, it has three combo boxes each combo box need to feed the next with choices that come from the previous boxes selection. I have so far three tables that I am using. I haven't attempted getting the...