advlegals
asked on
MS Access VBA - Advanced Tabular Forms
I have a tabular form which displays a matrix of values.
Is there any way to reference the dynamically generated form fields? I've created an on-click event and this works for all fields, I'd really like a mechanism for a click on any field to return a row and column identifier.
Thanks.
Is there any way to reference the dynamically generated form fields? I've created an on-click event and this works for all fields, I'd really like a mechanism for a click on any field to return a row and column identifier.
Thanks.
Me neither- I can't imagine what you are referring to.
Can you describe how these fields are getting onto the form.
Can you describe how these fields are getting onto the form.
ASKER
DatabaseMX:
For instance: My tabular form is based upon a table featuring three columns and three rows. Is there any form functionality/referencing mechanism that would return a cell reference for any given cell i.e. clicking on row 3, column 2 would return something like 3,2?
Thank you.
For instance: My tabular form is based upon a table featuring three columns and three rows. Is there any form functionality/referencing mechanism that would return a cell reference for any given cell i.e. clicking on row 3, column 2 would return something like 3,2?
Thank you.
Well ... I guess you could use the AbsolutePosition or CurrentRecord property of the form record source AND some sort of text box labeling scheme (eg txtCol1, txtCol2 ...) ... then display according to that,
mx
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry .... not really sure what you mean or are trying to do?
mx