Lookup values based on an input value 
Author Message
 Lookup values based on an input value

Hello I am having a problem doing something that I know
can be solved because I have seen it done before.

I have a form that I want to open with all fields blank,
then I want the user to input a value in the ID field,
with the value that has been put in the field I want to
pull up all the remaining information pertaining to that
ID number.  (i.e. ID #1 belongs to Jim Smith at 1234 Main
Street Anytown USA 12345) but I only want the user to have
to put the ID # in the form and have Access pull the rest
of the info as a text box not a combo or list box.

It just doesn't seem to work for me.  Does anyone have any
idea?



Sun, 19 Sep 2004 05:29:22 GMT  
 Lookup values based on an input value
Hi from an access amateur,
I made a details table with the client ID and then based a form on that and
the original table with all the client data. The form is blank until you add
the ID in the details client ID text box. It then updates all the other
fields. Hope this helps
Eleanor


Quote:
> Hello I am having a problem doing something that I know
> can be solved because I have seen it done before.

> I have a form that I want to open with all fields blank,
> then I want the user to input a value in the ID field,
> with the value that has been put in the field I want to
> pull up all the remaining information pertaining to that
> ID number.  (i.e. ID #1 belongs to Jim Smith at 1234 Main
> Street Anytown USA 12345) but I only want the user to have
> to put the ID # in the form and have Access pull the rest
> of the info as a text box not a combo or list box.

> It just doesn't seem to work for me.  Does anyone have any
> idea?



Sun, 19 Sep 2004 13:43:34 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Returning Multiple Values to a Lookup based on user input

2. Trying to lookup a value based on another field's value

3. lookup value based on another value Prob

4. display lookup value based on value entered

5. lookup list based on value entered in base table

6. Yes/No based on Value Lookup?

7. Lookup value based on multiple combo boxes

8. Lookup (based on calcauted value)

9. Lookup function based on adjacent cell value

10. Copying rows based on lookup value


 
Powered by phpBB® Forum Software © phpBB Group