A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms with searchable criteria



 
 
Thread Tools Display Modes
  #1  
Old August 21st, 2006, 05:29 PM posted to microsoft.public.access.forms
Andy
external usenet poster
 
Posts: 941
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.