Grid that changes the current record in text boxes

[hallm]

My form layout is a four tab page frame. The first frame has a grid that contains a list of my records. The other three frames have details for whichever row on the 1st page grid is highlighted. The code I'm using right now only seems to work the first time the form is run, it doesn't seem to work when another record is selected.

LOCATE FOR patient_id = ALLTRIM(THIS.Value)
THISFORM.Refresh

I was putting this in the click event for the actual textbox of the patient_id column. Another thing I'm wanting is for a click anywhere in the entire row to change the record.

Thanks,

Marion

 

[torturedmind]

SET RELATION can work in this scenario as well as linking your child tables (which are populating the grids in the other 3 frames) to the parent (grid data in the first frame) during the design of your form.

hope this helps. peace!

kilroy
philippines

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get one million miles to the gallon, and explode once a year, killing everyone inside."

 

[alvechurchdata]

Try running with the Data Session window running so that you can check thatthe record pointers are moving correctly.

Have you tried a This.Refresh in the Activate of each page?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[hallm]

This.Refresh works great. I'm not sure why it works, because I already had a this.refresh on the grid click.

Thanks,

Marion