Search 1st field and display corresponding 2nd field....

G

Guest

Hi, I would like the user to be able to look up the topics in a first field
of a database, choose one, then depending on which one the user chooses, that
corresponding memo field in that record will display. I would really like it
if the user could just begin typing and the fields will begin to "fill in"
automatically to make things quicker. It's a look-up system where the user
has to have answers a.s.a.p. depending on the topic. I'm sure it's pretty
simple, but I can't figure it out as I'm very new at this. Thanks.
 
R

Rick B

The combo-box wizard will write this code for you. When you add a combo box
to your form and start the wizard, the very first option it asks you
includes a selection to locate records based on the selected value.

A combo-box can also be set to ato-fill as you type.
 
G

Guest

Hi Rick,
Thanks for your help. I have one slight problem....the field that I'm
trying to display is a memo field and it will not come up in the wizard as a
choice field. It is a very long informational field that describes whatever
topic the user chooses. I'm trying to find the easiest way for the user to
just type in the topic(field: topic, type: text)in a combo box and when the
right topic comes up, I want the corresponding description to display in a
separate box below(field: description, type: memo). Sorry if this sounds
confusing.
 
R

Rick B

Your "topic" field is a memo? I would expect the topic to be smaller and
the explanation to be the memo field.

If your form is bound to a query, just add a new field to your query to pull
the first few characters of the topic and then use that in your drop-down.

PartialTopic: Left([SomeMemoFieldName],50)

This all concerns me a bit though - you are expecting your user to type the
topic exactly as entered? If it were me, I'd build a search box and let
them tner a search word ar phrase then have them click a button to perform
the search.


Rick B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top