Hi all, hoping you can give me some advice on a combo box issue I have.
I have places a combo box on a form to allow a user to select a well which has been assigned to a project. The table the combo box refers back to is tblWellsAssigned.
The table has a project ID field, a well ID field and well name field + some other ancillary data.
Now, im not a virgin with combo boxes. Ive used them hundreds of times but this is the first time ive hit this issue.
Basically, when I try to select an item from the combo box (it populates properly with only the assigned well names, both well id and project id are hidden columns) it doesnt work.
What I get when i click on the combo box is this:
Well1
Well2
Well3
but when I try to click on any of them, regardless what i choose, it will always rever back to Well1.
Any suggestions? Im stumped and i have searched the forums and internet religiously for an answer before bothering you.
Thanks!
I have places a combo box on a form to allow a user to select a well which has been assigned to a project. The table the combo box refers back to is tblWellsAssigned.
The table has a project ID field, a well ID field and well name field + some other ancillary data.
Now, im not a virgin with combo boxes. Ive used them hundreds of times but this is the first time ive hit this issue.
Basically, when I try to select an item from the combo box (it populates properly with only the assigned well names, both well id and project id are hidden columns) it doesnt work.
What I get when i click on the combo box is this:
Well1
Well2
Well3
but when I try to click on any of them, regardless what i choose, it will always rever back to Well1.
Any suggestions? Im stumped and i have searched the forums and internet religiously for an answer before bothering you.
Thanks!