Obligatory warning: Randy's site is aimed at VB programmers. Due to
differences in the controls available for forms in VB and in Access, most of
his samples won't port directly to Access without some changes. For example,
in VB you populate text boxes (or retrieve values from them) by referring to
the .Text propery of the control, whereas in Access you can only refer to a
text box's .Text property if the control has focus (you use its .Value
property instead). That being said, hopefully you'll be able to figure out
what you need to change.