current data show in datagrid

[abu taher]

I add some data in a form by text box. a acsess file store it.then I close this form
and open another form . that data show in this from by datagird or msflexgrid. but my
problem is when I add some data and close that form this data not currently show in datagrid
or msflexgrid. when I close full project and open it again then show all data. how can I
show it currently.

[AUGXIS]

hi. you can close the database after saving then open it again upon loading of the new form.

[abu taher]

Please help me with code and event.

[AUGXIS]

check first the state of your recordet. if its open then close it first
then open it again.

If rs.State = adStateOpen Then rs.Close
rs.open"Select * "

[abu taher]

I try it many way but I coud'nt. I connect my database with properties of adodc control. and write in recodesource like this code
select * from table1
so please tell me where I write code i mean whice form and what code.
please

[abu taher]

any body can help me please

[abu taher]

help me with this problem please.

[abu taher]

help me with this problem please.

[abu taher]

anybody help me

[aktharshaik]

Can u plz post the sample code where u r populating the flexgrid with the records?

[abu taher]

I didn't write any code. I put a data control. ms flexgrid connect with data control by properties. like data source = data1
another was datagrid. it also select by properties. i write sql like
select * from table1

[aktharshaik]

Check out the attachment.

[abu taher]

thanks dear but not like it. I mean I input a data in a from by text box and then close this form. after close I run a another form where a datagird contained. I want that data show in this datagrid.

[abu taher]

please check this. here in form2 I add any data by textbox and addnew button. when I close this form2 I want this new data show in flexgrid (form1) without click refresh button.

[aktharshaik]

Private Sub Command1_Click()
    Form2.Show vbModal
    Call cmdRefresh_Click
End Sub

[abu taher]

its not work.

[abu taher]

if you don't mind can you modify the attachement

[naim khan]

I add some data in a form by text box. a acsess file store it.then I close this form
and open another form . that data show in this from by datagird or msflexgrid. but my
problem is when I add some data and close that form this data not currently show in datagrid
or msflexgrid. when I close full project and open it again then show all data. how can I
show it currently.

well first u can create conection at form load and retrive all data from the database . if u have problem in code then i will explan ok

[abu taher]

Ok dear. can you modify my last attachment please. then I can get lot of help.