Using combo box to populate more then one field

[Alex Martinez]

Hello,

I am using Access 2002 and I have a form that use a table called claims and
another form that uses a table called inventory. Both tables have the same
fields called: PolicyNumber, Insured. The claims table will have an
additional field called claim date. The form Claims uses the claims table
and the Inventory form uses the table inventory. I will upload the data
from excel into the inventory table. What I want to do is to have a command
button in the Claims form right next the the PolicyNumber table box. When
the user press the button the Inventory form will appear and it will have a
combo drop-down box and I can select what policyNumber I want and have all
the fields populate the claims table when I close the inventory form. How do
I do this? The reason I want to have a separate form is that the
PolicyNumber field in the claims form I can inquiry what claims has been
submitted. Any example or website to visit will be appreciate. If there
is another way at this I would like to know. Thank you in advance.

 

[Ken Snell [MVP]]

Does the Row Source of the combo box have all the values that you want to
put on the form? Or do you want the combo box to "move" the form to the
correct record?

 

[Alex Martinez]

Hi Ken,

Thanks for your help.

Yes, the Row Source of the combo box (Inventory table) have all the values
that I want to put on the form (Claims form).

Regards,

 

[Ken Snell [MVP]]

Then this article may assist you:
http://www.mvps.org/access/forms/frm0058.htm

Post back if it's not quite what you're seeking.
--

Ken Snell
<MS ACCESS MVP>

 

[Alex Martinez]

Thanks Ken,

I will give it a try, if it doesn't work I will let you know. Good day.