Combo box as lookup

[Eskil]

hi,
I am using a combo box to search and return a specific recordset.

The function works fine when I just designed it using the wizard. I
type the first few letters of a client's name, and the autofill fills
in the rest and I can enter to see the given recordset.

Whenever I close my database and reenter it, this function no longer
works. I type the name, but no autofill. Of course, I can still use
the combo box by scrolling through the records and selecting, but I
know it should and can work better than that.

Anybody know what I am doing wrong?

TIA - Eskil

[Dutchy]

does it work if you first click the 'downarrow' of the box and then type a
name ? you might have no selection in the box the first time. on opening the
form you might need a comboboxname = "startvalue" line.

also try if comboboxname.dropdown works in the on_enter event.

--
Dutchy
Eskil <es********@hotmail.com> schreef in berichtnieuws
3d**************************@posting.google.com...

hi,
I am using a combo box to search and return a specific recordset.

The function works fine when I just designed it using the wizard. I
type the first few letters of a client's name, and the autofill fills
in the rest and I can enter to see the given recordset.

Whenever I close my database and reenter it, this function no longer
works. I type the name, but no autofill. Of course, I can still use
the combo box by scrolling through the records and selecting, but I
know it should and can work better than that.

Anybody know what I am doing wrong?

TIA - Eskil

[Eskil Krogh]

It does not work even when clicking the down-arrow.

You are right that I don't have any selection displayed in the combo box
when I open the form.

I don't understand what you mean by a startvalue line.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Larry Linson]

You might check to see that the AutoExpand property of the Combo is set to
Yes. It is, normally, set to Yes by default, and that is consistent with
your first use. I don't have a clue what would be resetting it unless
there's VBA code that does so. You might search your code for ".AutoExpand"
if you can stretch your imagination far enough to think that's the problem.

Larry Linson
Microsoft Access MVP

"Eskil Krogh" <es********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

It does not work even when clicking the down-arrow.

You are right that I don't have any selection displayed in the combo box
when I open the form.

I don't understand what you mean by a startvalue line.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dutchy]

in onopenform you may type a line like

me.comboboxname = "myfirstvalue"

and if it has to be a a value that is present in the combolist check that
"myfirstvalue" is one.
after opening the form there is now a (default) value displayed in the
combobox and that might do the trick.

you also might try me.comboboxname.requery which will rebuilt the list of
the combobox.

so far I have no more suggestions.

--
Dutchy
Eskil Krogh <es********@hotmail.com> schreef in berichtnieuws
41**********************@news.newsgroups.ws...

It does not work even when clicking the down-arrow.

You are right that I don't have any selection displayed in the combo box
when I open the form.

I don't understand what you mean by a startvalue line.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Eskil Krogh]

Hi,
Thanks for your input. As it turned out, my db was set to be SQL
compatible .When unchecking this option my combo auto lookup worked just
fine.

Are you planning to include this functionality also in SQL compatible
databases?

eskil
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!