Need grid blank upon opening form

[Kerbouchard]

I have a wizard created parent/child form in VFP 5.0

The outcome I'm after is that when someone opens the form, everything is blank.

I set the controlsources for the textboxes to (none) and that works great. The problem is the grid. When the form is opened it always shows the first record of the child table in the grid.

What's the best way to set this up so that the grid is blank until a search is done or data is entered?

 

[EricDenDoop]

What about not binding the grid to a table when the form loads? Just set grid.recordsource = "".

 

[BryonB]

Or you can bind the grid to a local view over the table - open the view with the NODATA clause initially, then when you know which records to display, you can requery the view. This works especially well if the view is parameterized (so you can specify which values to view for different grid columns).

 

[ramani]

Hi

Keep one blank record in your table and always reach that record when you get in. Or even.. append a blank when you get in.. and delete it or dont update it when you leave the form or change the records.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Kerbouchard]

Thanks for all the help guys. I ended up just setting the forecolor to pure white until I needed the data exposed. Thanks a million for the responses though!!!

 

[craigsboyd]

Kerbouchard,

There is a potential gotcha with that approach that you may or may not have thought of...if the user's color settings somehow change the background of the textboxes in your grid. It might be better to set the forecolor of the text to the background color if this is the approach you wish to use for hiding the grid data.

Slighthaze = NULL

[ul][li]FAQ184-2483
An excellent guide to getting a fast and accurate response to your questions in this forum.[/li][/ul]

 

[Kerbouchard]

Thank you slighthaze I hadn't thought of that.