Recent content by john3588

Thanks - Got it.

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...

Found it thanks. It was a bad link on the child property.

Thanks for the help. I have been doing this for some time and the video did not help. This is something quirky. :banghead:

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...