Autofill

[leebartley]

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

 

[Ken Snell [MVP]]

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