Thanks for your replies, I have followed what you have both said for me to do
and have the form now working BUT the data is duplicated on each record ie we
change record 3 and records 1 and 2 change to match record 3, have I missed
something on one of the settings. Thanks again for your help.
--
Thanks
Terri


"Terri" wrote:

OK here goes, hope this is clear

I am wanting to set up a database where info is selected in one field and
then multiple fields are populated. EG entering username from drop down list
automatically fills in Name, Dept and Ext so save looking all those up each
time.

In excel I would use the lookup function and put formulae in each cell.
Is this possible in access? Any help greatly appreciated.
--
Thanks
Terri