Run-time error 2448

MiAs

Registered User.
Local time
Yesterday, 18:24
Joined
Oct 25, 2004
Messages
49
Code:
cboNumber1_AfterUpdate()
Me.txtPerson1 = Me.cboNumber1.Column(1)
Me.txtEthnicOrigin1 = Me.cboNumber1.Column(42)

Bound to Column 1
table field 1 = Number
table field 2 = Person,
table field 43 = EthnicOrigin

I had this running ok until importing fresh table data now I get run-time error with:
*The object may be a control on a read-only form
*The object may be on a form that is open in design view
*The value may be too large for this field
 
This error means that yo can't change this field via VBA, (txtPerson1 or txtEtnicOrign1). Check the CONTROL SOURCE properties for this fields.
 
Thanks for that Stef,
You were right, control source problem with EthnicOrigin.
:D
 

Users who are viewing this thread

Back
Top Bottom