General information
Category:
Coding, syntax & commands
>Hi Nancy:
>
>Thank you for your response. I implemented your idea and got a VFP message saying:
>
>"Expression is not valid ouside of WITH/ENDWITH"
Er. Okay, probably means you have a syntax error in the line. *g* Probably a .Something that should be before the endwith. Or a .Something that shouldn't have the dot. IAC, I really didn't mean to distract you from the real issue.
>
>The reason I was redefining the captions for the grid was that when I did the Select statement to repopulate the grid, the field heading were displayed in lowercase as identified in the field name of the table's structure.
Right just more reason to think it's the problem with the recordsource.
Set the .RecordSource to ""
Do the Query.
Reset the .RecordSource.
What you do if you redo the select is you've close the table the grid is using, so it revers to a blank one. Then you reselect and it will be filled in with all it's defaults. default captions, textboxes, etc.
Previous
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