Combo Box Wizard does not offer three choices

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I need to make a listbox or a combobox to find a record on a form.

The wizard does not offer the option "to find a record .. .. . " or
something similar which I believe that I have seen in the past.

I have only two options in each case:

"I want the ****box to look up vales .. .. .. "

"I will type the values"

What am I missing??


Thanks,

Robin Chapple
 
If you are using access97 and the form is based on a query..for some strange
reason you only get two choices!

You can change the form back to a table...run the combo wizard..and then
change the forms data source back to your query.

In later versions of ms-access..this has been fixed.
 
If you are using access97 and the form is based on a query..for some strange
reason you only get two choices!

You can change the form back to a table...run the combo wizard..and then
change the forms data source back to your query.

In later versions of ms-access..this has been fixed.
Click to expand...


OK albert, now I'm really confuzzled. Because of our client's
platforms, we're still doing 60% of our development work in A97 and I
have never seen what you describe.

We base EVERY Parent Form on a Query and use lots of Combos yet this
is news.

Can I duplicate this somehow?


Cheers,
Brett
 
Brett Collings said:
OK albert, now I'm really confuzzled. Because of our client's
platforms, we're still doing 60% of our development work in A97 and I
have never seen what you describe.

We base EVERY Parent Form on a Query and use lots of Combos yet this
is news.
Click to expand...

I agree with Brett, Albert. I just tested in Access 97 using a form bound to
a query, and I got the 3 choices. Might it be service pack related?
 
Douglas J. Steele said:
I agree with Brett, Albert. I just tested in Access 97 using a form bound
to
a query, and I got the 3 choices. Might it be service pack related?
Click to expand...

Sorry about this. Here is how you duplicate this problem:

You have a form based on a table..and then hit the [...] button, and then
base the form on embedded sql..not query. If you do this..then you only get
two choices. And, I just checked...and this still occurs in a2003....


So, it is likely that the original poster invoked the query builder on the
table..and saved the sql in the form's data source. If you put in a query
name, or a table name..you can then use the wizard and you get 3
choices....then put back in the sql you had!
 
In addition to Albert's very reasonable suggestion as to cause -
you also only get the third option if the form is bound to a
recordsource.
If no recordsource is given for the form, the combobox wizard offers only
the 2 choices...

HTH
- Turtle
 
Douglas said:
I agree with Brett, Albert. I just tested in Access 97 using a form
bound to a query, and I got the 3 choices. Might it be service pack
related?
Click to expand...

I distinctly recall a service pack fixed this (just can't remember which
one). They need to ensure they have SP1, SP2 and the update for Jet 3.5
 
MacDermott said:
I'm confused here.
Our OP is using A2003.
Why are we talking Jet 3.5?
Click to expand...

Albert, Brett and Doug were referring to Access 97. I was responding to
that.
 
Well, Robin,
since the MVPs seem more interested in chatting with each other than
answering your question, I'll take a stab at it, although my understanding
of the issues isn't likely to be as thorough as theirs.

An Access MDB file contains both data tables and forms, reports, etc. for
manipulating and displaying the data.
Access forms and reports are easy to build and use, but using them does
require having Access installed on the PC.
However, it is possible to read Access data by using a much smaller
application, the Jet data engine. Jet can do a lot of interaction with
Access data, but it can't build forms or reports. Of course the Jet engine
is part of Access, but it's also available without Access. In fact, if I'm
not mistaken, it's part of the Windows XP operating system. It would be
difficult to use Jet all by itself, but it's fairly easily addressed using
programs like Visual Basic or C++.
As for the number - the format of MDB data changed between Access 97 and
Access 2000. Jet 3.5 was used to read Access 97; you need Jet 4.0 for
anything more recent. There have been a number of service packs for Jet.
(More, I think, than for Access itself) - I think Jet 4.0 is up to about
sp8.

HTH
- Turtle
 
Back
Top