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: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of Tina Currie

Sent: 20 August 2009 06:41

To: profox@leafe.com

Subject: Quirks of using controls within a grid

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

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]