Search results

Oops I made a mistake on the third part. I actually had the following: v1 = Me!DataEntry.Value v2 = Me!Site.Value v3 = Me!OperatorName.Value Sorry!

I have been reviewing all the threads concerning this subject and I got really confused because I don't understand all the code. I am trying to copy only part of a record on a form; three fields actually: Entry Date Site Operator name The site and operator name fields are cascading combo...

I finally got my cascading combo boxes to work. I figured out how to do it after spending part of yesterday and today reading all the posts on cascading combo boxes and looking at the samples. Thanks for all the help I received.

Sorry, I didn't answer all the questions. I am setting up the combo boxes with queries. I am using the WHERE clause in the Associate query: [Forms]![FormEntry]![ComboSite]. In the other equipment combo box, I am using a query with the WHERE clause the same. The combo box for the...

Thanks for your reply. I am having problems with the requery part. I have the following as the requiry for the first combo box where I want the site selected. Private Sub ComboSite_AfterUpdate() Me.ComboOperator.Requery End Sub How do I do the requiry for the ComboEquip if I am using the...

Thanks for your help. I finally managed to come up with the results I wanted but creating some queries. Basically I put in the criteria true in a query and then make another query for the count. I was able to create a report then for the calcuations. I'm sure it wasn't the best way. Sorry...

Thanks for all the help for creating combo boxes. Now I have come up with something I don't know how to do. I have two tables; tblAssociate which has two columns "Site" and "Associates. There are 7 different sites and I have creating cascading combo boxes after selecting the site, the...

If I use the criteria "true", then it brings back all the yes answers in the query. I then need a calculation. Each of the yes answers would be multiplied by 20. I thought it would be easier for calculation purposes to have the yes equal a "1" but I don't know how to do that. Thanks!

Sorry for the rambling. Sometimes it is hard to explain what you want to do when you really don't know for sure if it can be done. What I am trying to do is I want to return a "1" in a query when the answer is yes. The form I have is bound to a table and the form has a check box for yes/no...

I have a form whereby there is a yes/no check box. The box is checked if a die change was made in printing the labels. I want to be able to calculate the die change by 20 sheets of paper to come up with a waste calculation every time there is a die change. If I put in the criteria of true...

Thank you so much for your patience and help! I have finally got the cascading combo boxes working correctly after hours and hours and hours...... I don't know what I would do without the help I receive from the forum.

I sorry I am just not understanding. I have been going through all the examples and there are so many I am getting confused. I used the example of the two tables and connecting the tables with the Customer ID. Well the combo box worked right in selecting the customer name, which I wanted and...

Well I did my happy dance too soon! I thought I had the form working correctly as far as visually, but when I looked at my table to see if the information was being entered correctly, I was getting the customer ID number instead of name in the table. I thought I could just change the Bound...

Thanks! Such a simple thing I forgot. It is working fine now. I really appreciate your help!

I have created a form and on the form are combo boxes from tables. One of the fields is Operator. When I click on the combo box the list of Operators are shown and the one I select appears, but when I tab down to the next field I receive an error message that I must enter a value in the...

Happy dance! I finally got it to work. Thanks for all the tutorials and videos that you guys posted.

I created a query from my two tables Customers and labels Customer ID Customer Label 1 Bristol Farm 21-up 1 Bristol Farm 48-up 2 Cardenas 8-up 2 Cardenas 18-up and so forth with 10...

I am still working on my problem. Thank you so much for the information.

This is the first time I have tried to create cascading combo boxes and I have been working on it all day. My problem is when I get to the dependent combo box. I use a table source for the first combo and it is working until I enter the code for updating the dependent combo box. I have...

Thanks to everyone! I followed Sean's recommendation and I got the result I wanted! I never could get the IIF statement to work, so I gave up on that. Thanks again!!