A
Andy
Hi,
I currently have a form that dumps data into table A. Within this I
currently have a combo box that looks up data in table B as well as a
separate button that allows the user to search for keywords from table B
(through a select query). Ideally, I would like something that the user could
either enter in a code with a scrolling facilty (as the combo box currently
does), AND has a search function with the option to choose ONE of the
returned search values and to use this value. Manageable I know with queries,
but this wouldn't let the user see the returned code within the form...
i.e. if I knew the value I wanted was R222 I could enter it, scroll through
to find it, or enter R22* to return R220-R229 and a function from this to
select R222. Once selected, I want the form to show R222 as it would in a
combo-box.
One I may need to explain in a little more detail, and happy to do so.
Thanks
I currently have a form that dumps data into table A. Within this I
currently have a combo box that looks up data in table B as well as a
separate button that allows the user to search for keywords from table B
(through a select query). Ideally, I would like something that the user could
either enter in a code with a scrolling facilty (as the combo box currently
does), AND has a search function with the option to choose ONE of the
returned search values and to use this value. Manageable I know with queries,
but this wouldn't let the user see the returned code within the form...
i.e. if I knew the value I wanted was R222 I could enter it, scroll through
to find it, or enter R22* to return R220-R229 and a function from this to
select R222. Once selected, I want the form to show R222 as it would in a
combo-box.
One I may need to explain in a little more detail, and happy to do so.
Thanks