Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Again a grid problem ! 1

Status
Not open for further replies.

DannC

Programmer
Apr 5, 2001
75
RO
Hi,
I've create a grid based upon a SQL statement in RecordSouce . When it starts everything works just fine but I can't update it after I change something in the main table and issue Requery. Thak's.
 
Hi!

Look to site into tre FAQ section, article #739 (Grid reconstruction and how to avoid it). You will find there all information related to the requery of the grid record source.

In you particular case, to requery grid, assign empty string to the RecordSource, than assign SQL Statement again. Or just make query manually that is better for case if you will move to SQL Server later.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top