Thanks for the direction
it errors out instantly at:
Copy_Of_Build_Guidelines_Err:
MsgBox Error$
Resume Copy_Of_Build_Guidelines_Exit
with Error$ highlighted
I am a seasoned access user but I am expanding my database nationally, the use of VB would be of great help. I converted a macro into VB and then added to it but it will not run. Here is the code. Please let me know what I am doing wrong it errors out immediately.
Option Compare Database...
I have spent so much time on this but I cannot get it return only those rows where "Sorter" is unique and rate is the lowest for that group (Sorter)
The table looks like this:
Sorter Lender Loan Rate Price APR
101 1 $49,999.00 5.250%...