when i enter info into one field, based on that value, information is entered into another field?
For example... field 1 has a persons name, Robert Smith
when I type in Robert Smith, field 2 should automatically put in his phone number which would be in another table. Is this just a basic relationship and I'm making it out to be more than that or is there another way to do that?
" I thought those obtions (combo and list boxes) were just drop downs where the user chose a value. "
That's exactly what they are and it sounds like that's what you want.
Maybe you figured it out from teddy's responses, but just in case, maybe this will help (i'll use queries and a macro):
If you have a form based on a table (or query of a table) called PEOPLE, then all of your data should be available via the form, yes? (Your form should include the PK of the table). But to find someone you have to go from record to record which is a drag. So you want to find someone by simply typing in a name. So...
Add an UNBOUND combo box (or list box) called (something like) cboNames to the form. The row source should be a query of all Names from the PEOPLE table so when you 'dropdown' you see everyone's name.
The query must include the PK of tblPEOPLE, and the Name field(s).
Now you need a macro called (something like) AfterUpdateNames:
GoToControl [PK Field of Form]
Attach the macro to the After Update event of cboNames.