A
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.
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.