Combo Box trouble

[blake7]

Hi, I have created a normal combo box to choose from a set of initials in a
form, but when I open the form and click on the drop down arrow, only the
first initials are shown and the drop down list appears empty ? why can't i
see the other initials ? what am i doing wrong ! I am new to access so please
be kind !!!

Thanks Tony

 

[Wayne-I-M]

HI

Are the initals stored in a table? If they are you can open the form in
design view then open the toolbox (it's on the view menu) and then use the
wizard to create the combo for you.

After you have the combo done, if you want to do "something" with the
results (AfterUpdate, if the intials are a set order, Add to another control,
store the results, or many of things, etc, etc). Just post back with another
question and I'm sur someone will help.

 

[blake7]

Hi Wayne, Yes the initials are stored in a table, I have used the wizard and
it does the same thing, i cannot see the other options in the list. ??

Regards

Tony

 

[Wayne-I-M]

Couple of questions.

Are the initals stored in the same field in the table or in many
eg
Field1 = AB
or
Field1 = A
Field2 = B

also does each record have a unique identifier (normally an autonumber field).

If so can you give me the name of the fields (make sure you are accurate)

Lastly is the form based on the table or based on a query. Again can you
give me the name of the table or query the form is based on (bound to). Oh,
one last thing. Is this a bound form (just a thought)

 

[Tom Wickerath]

Hi Tony,

It sounds to me like you do not have a correct Row Source for your combo
box. When you click into this property on the Property Sheet, and then click
on the Build button, does the query builder open to a query that you can run
that displays the correct data? Perhaps show us a copy of the SQL statement
for your Row Source.

On the Format tab, what value do you have for the number of columns, and
what are you showing in the Column Widths property?

Have you ensured that the forecolor for your combo box is not the same as
the back color (for example, white on white)?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[blake7]

Hi Thanks again, I managed to download a fix for this error and its working
fine now, just one other thing thats driving me crazy, I created a form using
the wizard based on a query, everything looks ok but i cannot enter data into
the form ? what have i done wrong, i been trying to solve this for 2 hours
now - please can you HELP!!!

 

[Tom Wickerath]

What fix did you download for the combo box problem? I'm really curious about
that.

Can you enter data into the query that serves as the recordsource for your
new form? What is the Allow Edits property of the form set to?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________