Weird database problem. please help!

Hi,
i'm using ADO for my database project. and i'm aslo using SQL for my record source.
i have set a text box as a record source. it works fine when i use it but it gives me an error.
when i use it for SELECT...... it works well. but when i use it for INSERT..... it inserts the data i give to it but then gives me this message : OPERATION IS NOT ALLOWED WHEN THE OBJECT IS CLOSED. and then it closes the application.
what is this weird thing.
please help me.
thank you very much.

Any code? It is hard to help you without seeing what are you trying to do.

OK,
i have an ADO contro and a data grid control and a text box with a command button.
i connected the ADO with the grid and set the text1.text to be the adodc1.recordsource . and for the button i put in this code :

Private Sub Command1_Click()
Adodc1.RecordSource = Text1.Text
Adodc1.Refresh
End Sub


then when i type in for example :
INSERT INTO sign (username) values ('mike')

it enters the data correctly in to the database , but it also gives me that error and closes the application.
I hope you can help.


:)

Did you ever use a debbuger tool? Step through you code with debbuger and see wzap.

Sounds something like this:

You've connected a grid to your recordset. All works fine, when using select statements. But, when you use a insert statement, there is no recordset returned, so the grid can't be bound to it. I think herein lies the problem.

good luck.