Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using a macro that will write "1" to the input field "Confirmation".
Sub Faux_bris
set fld = ActiveDocument.Fields("Confirmation")
fld.SetInputFieldValue XX, "1"
End sub
XX being the row number where to write my "1" to.
I will have the users run the macro when only one possible line is selected in that reduces the Confirmation field to one row.
(does that make sense)
How can I get the row number to replace the XX value?
40 lurkers, no takers?
One last try, as I will be in deployment next week...
This won't work because selections within the gui to only one possible record didn't affect the macro in this way. You need to delivered the record-number directly - maybe per variable or fieldvalue over a rowno() from script or per functions like fieldindex() and fieldvalue.
- Marcus
Thank you for the input.
I'll have to look into that. I am fairly novice in Qlikview VBA, so what I'm hearing is
retrieve a rowno() from a cell that will be determined from a fieldindex()...
I need to do my homework before progressing in this. Yhank you again.
Simon