Hello Richard. This lesson is a good first stab at how to make practical use of VBA. But I seem to have a small issue with the NEXT button after changing from a macro to VBA.

When the CustomerF is first opened, the Company Name combobox at the top is blank.  No problem, so I selected XYZ Corp from the dropdown to check workings of the NEXT button. No go. Even with "XYZ Corp" in the Company Name Field, the NEXT button doesn't show me the next XYZ Corp name (Like Pete Smith). So I clicked on the binocular FIND button next to Company Name that we just converted to VBA, then the FIND button cycled to the next   record from XZY Corp.

It seems like the NEXT button does not set the focus to Company Name like the binocular Find button does. Is there a way to correct this?

Thanks!

---

Reply from Alex Hedley:

You could add a
CompanyName.SetFocus
To your converted code.
Is the code that was converted referencing the correctly named contols? None have changed name since. It sometimes hardcodes them