Hi Ashley.
>> process to zap and then re-populate a table displayed in a grid on page 2 and then makes page 2 active.
The result was an empty grid display. <<
My standard method for changing the Contents of the grid's RecordSource is to either use a parameterized view and requery it when necessary or to use an updateable cursor and zap it when necessary like so (where csrCategory is the grid's RecordSource):
*** Rebuild the cursor used as the recordSource for the grid
SELECT csrCategory
ZAP
SELECT * FROM Categories WHERE Categories.Cat_No = Thisform.Cat_No ;
INTO CURSOR Temp NOFILTER
SELECT csrCategory
APPEND FROM DBF( 'Temp' )
USE IN Temp
GO TOP IN csrCategory
This.nRecNo = 1
This.Refresh()
I never have a problem doing it like this.
Marcia
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only