Search results for query: *

Form Setup: Test Name Result Lower Spec Upper Spec Typical (combo1) (txtbox) (combo2) (combo3) (combo4) I would like to avoid manually selecting the test names. The test names are already in combo1 & i want all the names in the combo box to be selected and they are in...

Additionally on the same form, the user manually selects each test from the test name combo box. Is there anyway that when the form is loaded the first record(in the continuous form)/combo box would show the 1st row in the combo box, the 2nd record/combo box would show the 2nd row. (There's...

Roy-Vidar after all the replies, I finally found the one that works perfectly! The 3rd code: me!cboCombo.value = me!cboCombo.itemdata(0) on After Update works perfectly. You don't know much I appreciate your help!

I am not sure if this is the best way to do this, but what I am trying to do is on a subform & continuous form: Fields: Test Name Result Lower Spec Upper Spec Typical (combo1) (txtbox) (combo2) (combo3) (combo4) The user will Select the test name performed & enter the...

I think that would work if I needed the combo box to default when the form is loaded, but I actually need the combo box to default to the 1st selection after the selection of another combo box. Since the correct selection of the 2nd combo box will always be the 1st row, I am just trying to...

Thanks for being patient. I appreciate your help. This example helps. Thanks.

Yes, I read your reply, but I guess I don't completely understand. I have no problem with the cascading combo boxes based off of each other. My issue is how do I get the first row in the 2nd combo box to automatically always show up in the combo box without manually selecting it. If this is...

What code would I write(based off of the above code AceMan provided) if I needed the combo box to default not when the form is activated, but after the selection of another combo box on the form?

Try the "round" function. In text box: =Round(sum=[whatever],#of decimals to round to) & in the text box set the number of decimals to go to.

I am not having any luck with the above code. Let me see if some more info about the form would help. The form is a subform & is continuous forms. In this form we are entering test results. The 1st field is a combo box with the names of tests, you select the name of the test. Next field is...

I have a combo box on a form that is based off of a query based off of the selection of another combo box. The selection in the combo box needs to always be the first line item in the combo box. Is there anyway this 1st row can always come up after the selection in the other combo box. I am...