Access Form Event

[gheyman]

I have a button on a form. When I click that button I want it to change the value of a field (Combobox) on that form. The field on the form is named _NO_BID_RANGE_01

I tried with no success:

Sub Command1000_Click()

[_NO_BID_RANGE_01] = "NB"

End Sub

here is the source selection for that combo: "BID";"NB";"NQ";"MIN"

 

[Norie]

How is the combobox populated?

Is it bound?

 

[gheyman]

Sorry for the delayed response. I was stuck in a meeting Yes the combobox is from a table.

 

[Norie]

Does that table only have one field?

 

[gheyman]

No many fields, only one record so far, its under design phase

 

[gheyman]

MY BAD! I had more than one "Sub Command1000_Click()" in my code. once I deleted the other one, this worked.

 

[welshgasman]

MY BAD! I had more than one "Sub Command1000_Click()" in my code. once I deleted the other one, this worked.

Learn from this, give controls meaningful names.

 

[Norie]

If you had 2 subs with the same name then the code wouldn't/shouldn't compile.