05-24-13, 07:21 #1Registered User
- Join Date
- Apr 2013
Unanswered: how to change a combobox based on selection, number field to 0 on a main access form
Hey there any help will be appreciated Thanks I got a combobox field = name(txtCombo) And a numberField = (txtNumber)
Im getting a error something wrong with my code any help will be highly appreciated.Thanks
Private Sub txtCombo_Click()
If Me.txtCombo.Value = "Meter" Then
Me.txtNumber.Value = 0
error imn my code:
Run time error: '2448' You cant assign a value to a object, due to this code I cant continue my calcuation!!!
If I select the Meter value it must change the txtNumber to 0
05-24-13, 16:53 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
The error message indicated that txtNumber, for whatever reason, cannot have a Value assigned like this.
Is txtNumber Bound to a Field in the underlying Table?
Is it a Calculated Field, i.e does it have an Expression in the Control Source, or is it Calculated in a Query? Is it defined as an AutoNumber in the tabledef?
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007