Search results

Trying to so a simple sum (..) This is what the sql statement looks like. SELECT Sheet1.Field1, Sheet1.Field2, Sheet1.Field3, Sheet1.Field4, Sheet1.Field5, Sheet1.Field6, Sheet1.Field7, Sheet1.Field8, Sheet1.Field9, Sheet1.Field10, Sheet1.Field11, Sheet1.Field12, Sheet1.Field13, Sheet1.Field14...

I am using a combo box to select a record. Once selected it updates a subform to display parts of that record. The problem is when I use the dropdown to select the record I have to do it twice. If the combo box is empty and I scroll to the record I want and click on that record, the combo box is...