Combo Box

[Joe]

I have a table with among other fields, Provider Name, Tax ID Number. How do
I get the tax ID number to auto populate in the tax ID field when I select
the Provider Name?

Thanks.

 

[Klatuu]

Assuming the Tax ID is a feild in the table with the Provider name, you could
add a column to carry the Tax ID Number in the column. Then, wherever you
move to a new record, populate the control bound to the Tax ID Number field
using the combo's column collection.

 

[Jeanette Cunningham]

Hi Joe,
You can't do this in a table. There needs to be a table which shows the
Provider Name together with the TaxID number somewhere in either this
database, another database or a spreadsheet. Working with tables is not
recommended, use a form. On a form you can set it up to auto populate a
field in a table using a combo box. Post back if you need help to do this.

Jeanette Cunningham

 

[Joe]

Hi Jeanette,

Thanks for the input. In my initial post, I did not clarify what was
happening. Here is the situation: The information for tax id and provider
that I mentioned is already in a table. Data is entered into the data via a
from created based on the table. Until late October, we were able to select a
provider from a dropdown that has two columns - provider name and tax id #.
When selected, the tax provider name goes into one field while the tax Id
goes into another field on the same form. We can still select the provider
name and tax Id number however, the information for tax id # does not show up
in the table while the provider name does. This is what I was trying to get
some help on. Sorry about the long posting. I just wanted to briefly explain
the situation.

Thanks.

 

[Joe]

Thanks for you help Klatuu: The Tax Id is in the table with the provider
name. The problem is that when a new record is added to the table via the
form created based on the table, only the provider name field is populated
while the tax id # field remain empy eventhough the info is in the provider
name/tax Id column.

I hope this explanation gives you a better idea of what I am trying to solve.

Thanks

 

[Jeanette Cunningham]

Joe,
have you got it sorted now?

Jeanette Cunningham

 

[Joe]

Yes. Thanks you for your help!

Joe,
have you got it sorted now?

Jeanette Cunningham