Recent content by eaglewingmd

Thanks for the advice. I had looked there, and I had thought I was coding correctly. I just reviewed it again and I think I'm doing it right. This is the latest attempt Public Sub mupdate() Dim gen As String Dim wr As Double Dim fr As String Dim low As Double Dim high As Double gen = sx '(sx...

O.K. I have always had a problem conceptualizing scope and modules and variables and public and private. It’s like a mind road block. I have a form that entries are made in text box controls. Below is the code and it works in the form on an AfterUpdate event. I am finding that I need this code...