Combo Box

[Summer123]

Hello,
my combo box works fine and it updates the field as expected, however when i choose a value on the list, it brings up the appropriate records on the form but moves the name on the combobox to the next value, but the records still remain for the first value i chose, when i choose the second value, it brings up the appropriate records but it moves the name in the combobox to the third value and so on... i dont knwo whats going on and i have had it trying to figure out what the issue is.. can someone please help me out. i am attaching a sample DB so you can see what i have done and what occurs... as i know i wasnt really helpful in explaining it...
thanks!
Summer

 

[vbaInet]

Please copy and paste the code here for starters.

 

[Summer123]

not sure what you mean by code, its a combo box and the only thing i am doing is requerying the form... and the combo box itself has a query built in to do the selection. I have attached the Database in this forum, does that not help?

 

[vbaInet]

It's just a "long" process for some of us to get to the database. We would normally request to see the database when it's a complex problem.

What did you put in the SQL to filter the dataset? Let's see that.

 

[Summer123]

for combo box row source here is the SQL i have
SELECT tblClient.ID, tblClient.[Client name] FROM tblClient;

for record source of the form, here is the SQL that i have
SELECT tblclient_selection.ID, tblclient_selection.ClientName, tblclient_selection.[qryedit_200], tblclient_selection.[qryedit_201], tblclient_selection.[qryedit_202] FROM tblclient_selection WHERE (((tblclient_selection.ID) Like [forms]![Edit_Selection].[myselector] & "*"));

 

[vbaInet]

Your combo box should not be bound to a field.

 

[Summer123]

OMG ... thats all???? geez... thank you!!!!!!!!!!!!!!!

 

[vbaInet]

It was pretty simple right?

You're welcome!

 

[Summer123]

HELL YA!!!!!!!!!! I was going CRAZY!!!!!!!!!!!!!!!! THANK YOU THANK YOU THANK YOU!!!!

 

[vbaInet]

No worries... I had top open your form to see what was going on afterall.

I just had too many windows opened at the time so I was avoiding opening the db.

 

[Summer123]

nope i can understand and thank you for looking into it! really appreciate it!