Why can't I tab out of a combobox and keep my selection

[fcmedina78]

I am creating a simple form with a combobox that pulls it's store number
selection from my store information table. When I try to use the form if I
tab out of the combobox after making my selection it clears the value I
selected. If I make a selection and click the combobox then click another box
it will let me keep my selection??? Any Help?

 

[Jeanette Cunningham]

fcmedina78,
first thing to try - create a new combo box for this store number and test
to see if it works as expected. If it does, then delete the one that is not
working as needed.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[fcmedina78]

Yea, I tried that with no luck

fcmedina78,
first thing to try - create a new combo box for this store number and test
to see if it works as expected. If it does, then delete the one that is not
working as needed.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

fcmedina78,
We need a little more info.
How many columns for the combo, is the value you select in the first visible
column of the combo?
Is the combo bound - ie does it have a control source?
What code do you have attached to any events on the combo?
What other code on the form refers to this combo?


Jeanette Cunningham -- Melbourne Victoria Australia

 

[fcmedina78]

I have two tables:
The first is a basic store table with the following fields:
Store Number (key)-text field
Store name-text field
Zip code-text field
The second table has the following fields:
Autonumber (key)
Store Number-This is the field that I used the combobox this pulls from the
first tables Store Number field. I used the the wizard to set this up.
Dollar Amount-currency field
date-time/date field

the form I made to enter info for the second table uses a combobox that is
bound to the first table by the Key field (Store Number). I used the tool box
and wizard to add the combo box and did not change any other fields.

 

[fcmedina78]

To make it clear when here are the steps I take selecting:
left click the drop down arrow
left click a store number to make my selection
after that I press tab to go to the next box

Currently the only way I can make the combo work is to do the following:
left click the down arrow
left click a store number to make my selection
left click in the combo box
left click the next field in the form
if I do anything other than click the field my selection clears

 

[Jeanette Cunningham]

fcmedina78,
make a test form to enter info for the second table.
Only add the combobox and the other 2 fields - don't pretty it up - it is
just a test form.
Use the wizard to add a new combobox.
Now test this form to see if the combo works OK.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[fcmedina78]

OK so I figured this out. As it turns out I was using the wizard to create
the form quickly and added the combobox after so I could use the wizard
instead of configuring it manually. By adding the combobox this way it
screwed up the tab index. As soon as I corrected it my problem was solved.