Data Bound Combo Box.

[toolsofministry]

I am using a combo box bound to a table for cities. My main form has a data control.I want to populate the city field of the main from from the combo box. I cannot get the cities combo content to change when I advance the main form. Rather than show what is in the field of the next main form it still shows the previous content from the cities drop down box.

Any suggests on a solution of the problems. Is the problems with the properties of the cities combo box or is it a coding problem. I have four other field in the main form that I want to use to populate their corresponding field in the main form. I also want to add to the cities combo box if a new city is needed for the main form.

Thanks,

Jack Robinson

 

[lflee]

Hi,

I would try to use "Me.Refresh" in your code so that the main screen is refreshed with the new data from your combo box each time you go to a new record.

Also, I recommend using this help site: allexperts.com I got an answer to a problem pretty darn quick! Hope this helps.