I like to create the grid cursor in the form LOAD event (or grid INIT has

been used on a project or two) then a gridrefresh method

selects into gridtempcursor

select gridcursor

zap

append from dbf('gridtempcursor')

use in select('gridtempcursor')

It's more work, but the occasional grid layout going poof is cured.

Tracy

-----Original Message-----

From: Dave Crozier

Sent: Thursday, August 20, 2009 3:23 AM

Sounds like you are resetting the grid Recordsource.

Before you do the query set the recordsource to " " on the grid, then do the

requery and then set it to the cursor you have queried.

If this isn't the reason then is the combobox source an SQL Select or

another type such as alias or fieldlist? Knowing will help to solve the

problem but personally I would make the source an SQL select statement into

a discreet cursor.

Dave Crozier

-----Original Message-----

From: Tina Currie

Sent: 20 August 2009 06:41

Hi all,

First time posting to ProFox - hoping someone can help me as I've wound

myself into a bit of a knot with this challenge.

I have an order table and I'm grabbing a subset (by SQL query) into a cursor

that is readwrite. I use this cursor as the recordsource for a grid on my

form. Purpose of the form is to give the user ability to update 1 field -

they are assigning a truck driver to each order. The driver details are

from a drivers table and I'm using the firstname field as the rowsource for

a combobox within the grid.

User can choose what data to show in the grid by picking a date range from a

date picker control. Doing this runs the query again and updates the grid -

but every time this happens, I lose the combobox control in column2!

What am I missing?

TIA,

Tina