autofill is broken

[Jeff]

I have an access database that uses an autofill combo box. what a user does
is enter data into a add fucntional textbox and when he clicks add. the data
is suppose to go to that combo box. the problem is when you type in that
combo box for a specific item that was entered nothing shows up. we just
upgraded to office 2003 from 2000. it worked fine in 2000. any ideas?

 

[Jeff]

There is a refresh button that was created that would refresh the table that
the combobox was connected with.

 

[Jeff Boyce]

Jeff

Refreshing the table doesn't tell the form to requery the combobox.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Frank H]

So, you have three controls here: the textbox into which the user types, the
button, and the combo box?
Based upon some more guessing what you've got, here's some things to try...
First make sure that the AutoList Items property is set properly on the
property sheet for the combo box.
Check the control source property of the text box, and the combo box to see
if it is bound directly to a field; perhaps that is part of the problem.

In order for a new item to show up, the info typed in the text box has to
get into the RowSource for the combo box, so you need to track down why that
is not happening.

Since the Row source Type property in this case could be Value list or
Table/ query, let's assume that it is Table/ query. If so, then whatever is
typed into the text box has to get into the table from which the combo box is
querying the list.

Try going to the button's OnClick event property; is it a macro, or an Event
Procedure? In either event, click into the property, hit the builder button
and take a look at what is there. That seems to be your starting point; see
where that takes you.

(If it is as event procedure, try recompiling the code (in the VB Editor,
goto the Debug menu, and pick recompile (db name). Perhaps it will point out
a line of code that needs to be fixed.)