Microsoft Access Forms

[Sher42]

I have a GL Code table which lists a GL Code Number and GL Code Description. I also have a purchasing table.

I have designed a Purchasing form based on a Query that references the two tables. When entering a GL code number in the form I want the corresponding GL Code description to be automatically displayed.

How is this best accomplished?

 

[PHV]

Simply use a ComboBox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Sher42]

It works but not as I thought. Mu first column is numeric and second is text. When I do the combo box I get numerics in both. I also tried doing a join in a query (&""&) and again got numerics for both although if I do them independantly they view as numeric and text.

I must be doing something wrong such as in an improper relationship but cannot straignten it out. Any help is very much appreciated.