Populating a form

[dagoat10]

I am trying to make a form that i can enter in data for a table. The 2 tables that i am trying to work with is a Players table and a TeamLink table. What i want the form to do is if i type in the name it will give me the corresponding fields for that record, because i can't remember all the ID's of each player. I tried a combo box but that's not working very well

 

[TheAceMan1]

How are ya dagoat10 . . .

Be aware: ... here at tek-tips, not only can't we read minds ... but we have no Idea what your looking at!

You say:

[blue]I am trying to make a form that i can enter in data for a table ...[/blue]

Indications are a [blue]single[/blue] form. Then you say:

[blue]The 2 tables that i am trying to work with is a Players table and a TeamLink table.[/blue]

We've now advanced from 1 table to 2. You continue to say:

[blue]What i want the form to do is if i type in the name it will give me the corresponding fields for that record ...[/blue]

[blue]How can we be sure of what it is you want to do?[/blue]

Think before you reply! ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]