Updating a combo box

[dcyale]

I give up. I have spent hours trying to get a combo box to update when the user types in something other than what is on the list. I have tried the refresh, notin list, bribery UGH!!
The form I am using is based on a table--one of the fields is based on a combo box. In the AfterUpdate event, I entered Me. Refresh. Nothing. Tried Requery. Nothing. Tried the NotInList which got way too confusing.
I created a sample form with the source being the combo box table and created a combo box on the form based on the combo box table. In the AfterUpdate, I put in Me. refresh and it works great.
I believe the problem is that in the main form, it doesn't know what to refresh? I don't know. I just figured I had better stop short of pulling out my hair and alienating everyone around me with cries of frustration. Please don't hate me because I'm stupid.

[MMcCarthy]

You said you tried requery. Did you try to requery the combo box or the form?

I give up. I have spent hours trying to get a combo box to update when the user types in something other than what is on the list. I have tried the refresh, notin list, bribery UGH!!
The form I am using is based on a table--one of the fields is based on a combo box. In the AfterUpdate event, I entered Me. Refresh. Nothing. Tried Requery. Nothing. Tried the NotInList which got way too confusing.
I created a sample form with the source being the combo box table and created a combo box on the form based on the combo box table. In the AfterUpdate, I put in Me. refresh and it works great.
I believe the problem is that in the main form, it doesn't know what to refresh? I don't know. I just figured I had better stop short of pulling out my hair and alienating everyone around me with cries of frustration. Please don't hate me because I'm stupid.

[MMcCarthy]

Post the code you are using in the after update event of the combo box

You said you tried requery. Did you try to requery the combo box or the form?

[dcyale]

You said you tried requery. Did you try to requery the combo box or the form?

The only code I have used is Me.Refresh or Me. Requery. I put in the properties for the combo box. I created a test form based on the lookup table and a combo box based on the field in that table and Me.Refresh works great. But when I try it in my main form (which is based on a table where one of the fields is the combo box) it doesn't work. Someone told me to try using DISTINCT as the query, but I don't like the idea of having to rely on what's in the main table. It seems that this should be so simple.

[MMcCarthy]

tey:


Me.ComboBoxNane.Requery

[dcyale]

tey:


Me.ComboBoxNane.Requery

I'v e decided to go the route on a self-query on the table. The database is going to be used by only one person who is comfortable with Access so I think it will work all right. Who knew it would be so difficult to add data to a combobox.

Thanks for the help.

[NeoPa]

Have you got 'Limit to List' set to 'Yes' for your ComboBox?

That might cause your problem.