Stay with me....

(Sheet A) I have a table with the fields customer name fax and email that is
blank

(Sheet B) In a seperate table I've made a list of customers names faxes and
emails of every customer we use.

When I enter in the name of a customer in sheet A, I would like the rest of
the information for the other cells to automatically fill in with its
coinciding information.

And I know their not cells, I just came from excel and I'm new in Access

You're going to have to overcome your Excel background!

There's no reason for two separate tables. Have one table, and create a
query that return all rows from the table that have Null for fax and/or
e-mail.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"HoganD87" <(E-Mail Removed)> wrote in message
news:4EDB9299-2198-45DA-90BB-(E-Mail Removed)...
> Stay with me....
>
> (Sheet A) I have a table with the fields customer name fax and email that
> is
> blank
>
> (Sheet B) In a seperate table I've made a list of customers names faxes
> and
> emails of every customer we use.
>
> When I enter in the name of a customer in sheet A, I would like the rest
> of
> the information for the other cells to automatically fill in with its
> coinciding information.
>
> And I know their not cells, I just came from excel and I'm new in Access