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

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.

--
Rick B


Quote:
> 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.



Fri, 23 Nov 2007 22:58:51 GMT  
 Search 1st field and display corresponding 2nd field....
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.
Quote:

> 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.

> --
> Rick B



> > 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.



Sat, 24 Nov 2007 00:43:07 GMT  
 Search 1st field and display corresponding 2nd field....
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


Quote:
> 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.


> > 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.

> > --
> > Rick B



> > > 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.



Sat, 24 Nov 2007 01:52:51 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Form field that will display number corresponding to another field

2. Add a field from 2nd table to report generated from 1st table

3. Combo Box selection wont display corresponding fields

4. grouped maximum field value and corresponding other field value

5. Displaying: date: 1st, 2nd, 3rd, 11th, 21st

6. Displaying Day as 1st, 2nd, 3rd, etc.

7. Fill Many Fields By Entering 1st Field

8. Triggering 2nd show on 2nd PC from 1st show

9. Field Enabled only by 2nd field contents

10. Text search on Memo field and display all records with that text


 
Powered by phpBB® Forum Software © phpBB Group