Access Question

[sdkfz]

I have been asked to modify an access 97 database some one else designed.

Before going into the details below, what I am looking for is the name of the process so I can look it up, kinda like if you do not know "concatenate" you'll never figure out how to add together two text fields.

Details:
On a form the users select from a combo box a mutual fund name. The data source for the combo box is a table. Then they have to manually type in a ticker symbol for the mutual fund and a percent this fund makes up of the total portfolio. Lots of room for error in typing in the ticker!

What they want is when field (fund name) is populated in the combo box, the associated field (ticker symbol) is populated with the associated ticker symbol. The percent allocation will still be amnual entry.

The data once entered is stored and displayed as the actual text.

The combo box data table has two elements - name and ticker both as text.

The form has 10 possible mutual funds to populate with names/ tickers/ percent of portfolio this fund is. So there is a fund name 1, fund ticker 1 etc.

Thanks

[doctorgonzo]

I think what you are looking for is DLookup. If I understand you right, what you want is for the ticker symbol to load automatically after the user selects a mutual fund from the combo box. The DLookup function is almost like a quick-and-dirty query: it will return the value of a lookup in a table.