General information
Category:
Forms & Form designer
>>>>If I use "Thisform.Grid(n).Column(n).Text1.value = fieldname", shouldn't what's in the field show up in that column?
>>>>
>>>
>>>Unless you built one yourself, Form objects don't have a grids collection.
>>
>>Sorry, on this particular form I have two grids...Grid1 and Grid2.
>>"Thisform.Gridname.Column(n).Textname.value = fieldname"
>
>
>Ok, then
>
>>If I use "Thisform.Gridname.Column(n).Text1.value = fieldname", shouldn't what's in the field show up in that column?
>
>Maybe, but that would be the wrong way to do it. If you want to replace the value of a field that the grid is bound to, then do a REPLACE on that field.
>
>
>>If I use "MyVariable = Thisform.Grid(n).Column(n).Text1.value", shouldn't MyVariable be the value in the textbox?
>
>Maybe, but that would be the wrong way to do it. If you want to assign the value of a field to a varaible, use the field itself.
>
>See the theme? Try to get away from trying to manipulating the value of bound fields in a grid, and deal with the underlying fields directly.
Youre right, I know. But with me it's never that easy - what I'm trying to do is more complex. The dropdown selection in the 1st column determines the rest of the data in the active row, and all this data is REPLACED into a fresh, empty cursor, which is the recordsource...Boom - next row active. I can almost see a big circle here.
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