If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms with searchable criteria
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 |
Thread Tools | |
Display Modes | |
|
|