By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

Combo box as lookup

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a


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!
Nov 13 '05 #3

P: n/a
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!

Nov 13 '05 #4

P: n/a
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!

Nov 13 '05 #5

P: n/a

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!
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.