Having Runtime Probem....

[soni_nandan]

Its Showing error as :

Run-time error 3426

"This Action Was Cancelled By an Associated Object"

i just wanna add record in access database... the error is highlited at first line only

when m using


Plz help me out.....

[RhinoBull]

You will need to post your actual code. If you don't where it happens then press the Debug button.

[soni_nandan]

Thanks RhinoBull..... i've fixed that error and can u plz tell me.... how many maximum no. of data fields we can take while managing data base with Access.... if m taking 20 fileds then its working properly n if m taking 23 fields then again it showes error like "Run time Error 3265 : Item Not Found In this collection"

And it highlightes 21st textbox
i.e
Data1.Recordset![SAMPLE RESULT DT] = Text21.Text

if its upto 20 data fields then its working properly

[RhinoBull]

The error has nomthing to do with number of fields but rather YOU not including "SAMPLE RESULT DT" field in your select statement.
To resolve this issue make sure that field is included in your selection which is again related to question I asked previously: can you post your actual code?