Hello,

Can anyone help me understand how to reference the fields/objects on a form
when querying/updating database tables?

Example: Form name = "frm_Cont_master"
1.  SSN  (text box)
2.  First name   (text box)
3.  Last Name   (text box)
4.  Company  (Assume this is a combo box selecting Company name and/or
Company ID number from a seperate lookup table).
5.  Department (Assume this is combo box selecting department name/number
from 2nd lookup table, based on the value in #4 above).    Assume Company ABC
has departments 1-5 and Company XYZ has departments 6-9.  Selecting ABC in #4
will yield a list with departments 1-5.

Assume the form name is frm_Cont_master.  Each field on the form will be
stored in 1 or more tables.

I will be performing updates so I do I refer to each object on the form so I
can format the SQL update statement?

Thanks in advance,