Hi Jeffrey.
Me again (s). As I said earlier, I don't use SQL as RowSOurceType for my grids, so I couldn't resist playing with it and I think I have an even simpler answer for you.
I don't know if your control into which the user enters an id is a text box or a combo box. It would probably be easier for the user if it were a combo box, but this code will work regardless of which one you use.
Set the grid's RowSourceType to 4-SQL Statement.
Put this in the grid's RowSource:
SELECT .F. AS PICK_DEL, CDC_ID, SPECNO, UNIQKEYSAS, UNIQKEYBAY ;
FROM CDCHIV WHERE CDC_ID = This.Parent.Text1.Value INTO CURSOR TEMP_HIV
Now, to make it work, put this code in the valid of your combo or text box used to enter the id:
LOCAL lcSQL
lcSQL = This.Parent.Grid1.RecordSource
This.Parent.Grid1.RecordSource = lcSQL
I just tested it with data of my own and it displays the correct data in the grid.
Marcia
Previous
Next
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