Grid Cell containing Memo filed to display in textbox 1

[BarryPCI]

I seemed to have posted this in the wrong place so I am reposting it here in Forms and Controls area.

I have created a one-to-many form that hold account records (parent) and communitcations with the account(child).

the child records are displayed in a grid (grid1) on the form (form1). The grid has four columns 1) Acct code 2) Datetime 3)Comment 4) Response

Column 3 & 4 are "memo" fields in the datatable. I also have two additional editboxes on the form Edit1 and Edit2 that displays partial contents of Comment and Response from the Grid.

The first row in the grid displays the correct information in the Edit1 and Edit2 controls. What I need to happen is when the user moves to the next ActiveRow the information (Memo) should change in Edit1 and Edit2.

What am I missing here to have the data refresh.

I have tried:
"thisform.edit1.value = thisform.grid1.column3.text1.value"

 

[wsmyth]

Cheers BarryPCI!

Look at the AfterRowColChangeEvent property of the grid.

Put a little bit of code like...

thisform.edit1.refresh()
thisform.edit2.refresh()

and it should work for you.

HTH

 

[BarryPCI]

Sorry HTH this did not solve the problem.

I agree that whis should logically work from the surface but does not. The AfterRowColChangeEvent should allow it to pick up information from the grid and pass it but ???

Does the ControlSource of the EditBoxes need to be pointing to the Grids ActiveCell(nRow,nColumn) 'somehow' or else??


Thanks community

 

[MarciaAkins]

Hi BarryPCI.

You need to set the ControlSources of the edit boxes the the grid's RecordSource and Field (Alias.Field). Then when you refresh() them in the grid's ARCC, they will contain the information from the current row of the grid's RecordSource.



Marcia G. Akins

http://www.TightlineComputers.com