Data Lookup or query?

[p-rat]

I have two fields (text boxes). Text box 1 is a Location and always
has data inputed. Text box 2 is an Sub Location but only sometimes
gets data inputed.

I would like to be able to pull up that if Text box 1 is being filled
in that prior data that matches pulls up and also if there is any
matching data for Text box 2 that it would get filled in autmatically
too.

I guess almost like a combo box where it will recognize from a query
or whatever, but then also automatically fill in the next field (text
box 2)???

 

[Jeanette Cunningham]

You could change the text box 1 to a combo that has both the value for text
box 1 and the corresponding value for text box 2.
In the after update event of the combo, you can set the value of textbox 2
to the value from the appropriate column of the combo.

Jeanette Cunningham