Combo Box populates every field

[jk42]

Hi,

When I enter a combo box on a form, whatever I choose from the combo box, it populates everything. If I go to a different row to change it, it changes them all. How do I get that to stop? And why does it do that?

Thanks!

 

[catalin.petrut]

I assume that that combobox is unbound (no control source). Right? If so, you'll have to know that this kind of fields will act like this. Is nothing you can do. Maybe we can help with a solution if you tell us what you need from that combo box to do.

 

[jk42]

Yes! And I honestly can't figure out how to bind it, or where to bind it. I have a form that I'm using for data entry for our project information. Maybe I'm using the co mBo box wrong, but I thought I could use it to have the data entry person either select a project type from a list, or type it in. Each project could have a different type. Does that make sense? I'm slooooowwly figuring out thi gs in access, but somehow the more I learn, the further I get from having my database completed! Thanks so much for any help!

 

[catalin.petrut]

If you use the wizard to create that combobox, at one step you'll have to chose where to store that value. That is the easy way to bind that control.

 

[jk42]

Thanks! What do you mean by where it stores the value? Like I. A table or something?

 

[catalin.petrut]

You'll have a value on the combobox, right? That value can be stored into a field from a table. That field can be selected on the wizard of the combobox. Use the wizard. Read the text on the wizard and you will get it. Is pretty clear.

 

[catalin.petrut]

Or you can upload your db and maybe someone will help.