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: [email protected] [mailto:[email protected]] On Behalf Of Tina Currie Sent: 20 August 2009 06:41 To: [email protected] 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6175b84851c44fc6b5f38497f1bba...@develop ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
