Member Avatar for PM312

I have form name FRMABC with msflexgrid

Msflexgrid get populatd by data from table msaccess database on form load event of FRMABC
There is one command button on FRMABC which opens another form say FRMPOR where new data is added on to database table

There is subprocedure (Public) SubRefresh on FRMABC for refreshing the msflexgrid by deleting old data on flexgrid and populate new data after addition of new record in table

But msflexgrid dosen get refresh when i call it from FRMPOQ

‘Code on FRMPQR on SAVE command button
Call COMMON.TBLCTITLECn(TBLCTITLECn, TBLTITLERs)
TBLTITLERs.AddNew
TBLTITLERs.Fields(0) = Text1.Text
TBLTITLERs.Fields(1) = Text3.Text
TBLTITLERs.Fields(2) = Text4.Text
TBLTITLERs.Fields(3) = Text2.Text
TBLTITLERs.Fields(4) = Text5.Text
TBLTITLERs.Update
Call FRMABC.SubRefresh
Unload Me

  • 2 Contributors
  • 3 Replies
  • 548 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

Try -

MyGridName.Refresh
Member Avatar for PM312

not working

i tride unloading and reloading form but still grid data dosen change.

Member Avatar for AndreRet

That might be because the datagrid is on form FRMABC

FRMABC.MyGridName.Refresh
FRMABC.Show
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.