Getting information from another table

[mlamont]

I have a form which allows me to add information into a table, however I need to verify specific piece of information against information from another table.

For example:

I have a field named Claims ID, when I enter the Claims ID number I want to be able to press a button called Verify and I then need to have a textbox pop up and show the Last Name that is associated with the Claims ID in another table.

I hope this example is somewhat clear. I need some help getting started.

Cheers,

Mike

 

[Pat Hartman]

Why not just show the LastName on the update form. To do this, base the form on a query that joins the two tables. When you tab out of the ClaimID field after entering a claim number, the LastName field will be automatically filled. Make sure that you set the Locked property of this field to Yes since you don't want anyone to accidentally change it.

Another alternative is a combobox that shows both ClaimID and LastName.