User wants faster "find record"... 1

[gusbrunston]

I'm designing a form that displays/edits clients. In the form header, I display a text box with the last name of the client for the open record. Although I have arrows with goto first, previous, next, last record arrows, and a find record command button, the eventual user(s) wants to be able to key in the name of any client in the text box and "auto-fill" the box with the name(s) of existing clients and then hit enter to go to that record when the right name shows up. I did this for them in their old program using Pick Basic. Can you help me do it in Access2000? Thanks so much. (Sometimes I think I'm using your help too much, but you must enjoy it, or you wouldn't keep logging on here!)
Gus Brunston

 

[gusbrunston]

unhh! I did it myself! With a combo box--exactly what the client wanted. Since I'm answering my own questions, either I'm getting smarter or my questions are getting dumber. Sorry to waste this space.

 

[RickSpr]

Gus, I'm glad you're catching on to the Access mindset. Pretty soon you'll be able to help us out with all these questions, questions, questions!

Don't think of it as wasting space. Somebody else with a similar problem may find your post and be helped, since you took the time to say how you solved it. Thanks! Rick Sprague

 

[RogerU50]

Hi,

I am trying to do the same sort of thing.
Sorry, I did not catch the solution.
When I use a combo-box without further code,
manipulating data within the combo box does
not do autofill, but rather just changes the
data in the table to what I type. Am I missing
something?

Thanks.

Roger Ullmann

 

[gusbrunston]

Hi Roger,
Here's what I did:
1. Drew a combo box on the form header;
2. In the property sheet, Row Source Type = Table/Query
3. In the Row Source there is this expression:

SELECT [NameOfQuery].[OwnerLN] FROM [NameOfQuery];

4. In the Default there is: [NameOfBox].[ItemData](0)

The only problem I had was that when I opened the form from the main switchboard the combo box window was vacant (the values were there ok). To solve this, I "requeried" after the combo box got the focus (with a macro).

If this isn't clear let me know, and I'll go into more detail. Best to you, s-)


Gus Brunston
An old PICKer
padregus@home.com