How can I use a Unique ID and retrieve data from the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has a text box with FileNo which is the unique identifier.
And I want any time a FileNo is enter, some specified data will be retrieved
from different fields in the table.
 
If I did understand very well what you meant by the text box "bound" to a
field in the table, I may say no. But the fact is this, the properties of
this text box have it's control source to the FileNo, the Row Source to the
table and the Row source Type, to the query table. The FileNo is a unique ID
to all the fields in the table. So I want a situation in which if the user
enters any FileNo of his choice, it will pull up or retrieve some specific
information that is associated with that particular FileNo, from the table.
Or if I use, a combo box and the user makes a selection of the fileno he
wants and click enter, the specific information associated with the fileno
will be pulled up.

Thanks for your help in advance.

Zetony
 
Zetony,

Can you please be a bit more specific about what you are trying to do? Is
the text box with FileNo bound to a field in a table or is it something that
you are trying to use to pull up information in a table that is indexed by a
FileNo field?
 
Back
Top