Making Combo Box fill in after new item is added?

[poucedeleon]

Load Combo box data from a Form

Pam I was able to take the original sample database that was posted and clean it up a bit and get it to work. I have not gotten it to work in my db yet. The difference being this is filling a single field and I have a concatenated field. I am attaching a copy of the cleaned db hopefully this will help you out some.

 

[pam0566]

Making combo box fill in after new item is added

I tried that, thx , but now when i do that my "cbomodel" reverts to wrong info. I am sending uploading a copy of my Access 2007 data base. on the FRMvehicles i have a command button Add model. I want to [if the model is not in the cbomodel field] click on add model, add a new model to the list [and those lists should only be what is listed to correspond with the make i selected -- this works fine] and then when i go back after adding a new model the model is on my frmvehicles. not sure what i am doing wrong .. after i added the code as you had in your data base.. the wrong model info for make was selected. thanks! Pam

 

[pam0566]

Hi, I Am Havin The Exact Same Issue, How Did You Resolve It?

 

[poucedeleon]

Making Combo Box fill in after new item is added.

I have my code at work. I work graveyard, so I will send you the code and a sample of my db tonight. Hopefully it will help you resolve things.

Kevin

 

[pam0566]

Thanks for a quick response! i got that handled [forgot to browse thru page TWO of this post.. duh]. BUT maybe you can help me with a similar problem.... similar, not same or i would copy my approach to the dealer table and sleep better tonight! if yo ulook at my form [frmvehicles] i have a cascading combo box for MAKE and MODEL. When you select a vehicle make, the combo box for models [cbomodel] only shows the models that correspond to that particular make. BUT i want to either use a button or a popup form, taht if a model isnt listed i can open frmmakemodel subform and add teh model to a table that is already filtered by the make that was selected. So far so good. NOW (and here comes the tricky part), i would like after i add teh model and close that form [frmmakemodel subform] i would like the Model i selected to be already showing on my Form [frmvehicles] in the Model field. I dont know WHY its so difficult. thanks to some assistance i have that working on the DEALERS combo box, (same form) and the submode. HELP!! if you could look at this and offer a suggestion as to what i am doing wrong i would be so grateful! Thanks! I am submitting a copy of my data base for review.. thanks so much

 

[pam0566]

I am trying to have a pop up form come up when a model isnt on list... but i want it to be the models corresponding to the make i selected. I add teh new model, then when i close the form the model field on my frmvehicles is populated with my new addition. this works for my dealers combo.. but for some reason not for the models. must have something to do with the model id's etc. I get this error when i try to add the model : Run-time error '-2147352567 (80020009)': THe value you entered isn't valid for this field. I am assuming it needs a makeid or model id but am not sure how to fit that in. Adding copy of DB again.. HELP anyone?