List Box updates itself from text box entry.

[Craftsman61]

Hello guru's and interested parties.

I need direction in finding a solution to something I am working on.

I have a text box (txtReqNum)which uses the access standard macros of first record/last record etc... I have also a list box (lstReqNum) which displays all the ReqNum's in the database. As I use the access provided buttons and move record to record the list box adjusts itself perfectly. but when i press the access provided add record button and start entering the ReqNum for a new record the list box stays put at the first record. What I would like the list box to do is to adjust itself to the entered text box data, character by character - sort of like a visually proactive duplicate checker. As you type in say B , the list box goes to the first B. When you next type in a L, the list box displays the first BL record and so on.

Any suggestions ?

 

[JeremyNYC]

Have you thought about using a combo box? I'm not fully clear on what it is you're trying to do, but it sounds like a combo box might offer you all the functionality you're looking for.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[Craftsman61]

Thanks for the response Jeremy.

what I am after is this. I have a text box that the user will type in a Request Number (txtReqNum). Before the user starts entering data the list box (lstReqNum) displays all the request numbers is the database. As the user enters into the text box the first character say a B the list box would requery or filter itself to show all request numbers that start from B, and so on for each character until its narrowed down so the user to see if that request number is in the list box or not (this way they have a active display to see if what they are entering is a duplicate entry or not).

I have followed the idea to have the list box based on a query with criteria selecting the txtReqNum and using an after update event but I can't get it to work right.

Any suggestions or directions ?

 

[JeremyNYC]

Yeah, I would go ahead and use a combo box with autocomplete set to true. Try it, and see if that does what you need.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[judgehopkins]

Where do I set to true the autocomplete in a combo box? Judge Hopkins

"...like hunting skunks underwater...."
John Steinbeck, The Grapes of Wrath