Autofill

I have a database with Ins Company info. I have set up a combo box but would
like to have all other fields auto fill once I lookup the Insurance Company
name.
My fields are named as follows. InsIntCP for Insurance Company,
InsAddress for Address, InsCity for City, InsProv for Province and InsPostal
for Postal.

This is the code I put in Beforeupdate event.

Me.InsAddress = Me.InsAddress.Column(1)
Me.InsCity = Me.InsCity.Column(2)
Me.InsProv = Me.InsProv.Column(3)
Me.InsPostal = Me.InsPostal.Column(4)


What am I doing wrong??????

Lee

See The ACCESS Web for one way to do this:
http://www.mvps.org/access/forms/frm0058.htm

--

Ken Snell
MS ACCESS MVP


"leebartley" wrote in message
...
I have a database with Ins Company info. I have set up a combo box but
would
like to have all other fields auto fill once I lookup the Insurance
Company
name.
My fields are named as follows. InsIntCP for Insurance Company,
InsAddress for Address, InsCity for City, InsProv for Province and
InsPostal
for Postal.

This is the code I put in Beforeupdate event.

Me.InsAddress = Me.InsAddress.Column(1)
Me.InsCity = Me.InsCity.Column(2)
Me.InsProv = Me.InsProv.Column(3)
Me.InsPostal = Me.InsPostal.Column(4)


What am I doing wrong??????

Lee