<div>
&quot;s there any way to reference the dynamically generated form fields&quot;<br />
<br />
Sorry .... not really sure what you mean or are trying to do?<br />
<br />
mx
</div>


"s there any way to reference the dynamically generated form fields"

Sorry .... not really sure what you mean or are trying to do?

mx

<div>
Me neither- I can't imagine what you are referring to.<br />
Can you describe how these fields are getting onto the form.
</div>


Me neither- I can't imagine what you are referring to.
Can you describe how these fields are getting onto the form.

<div>
DatabaseMX:<br />
<br />
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?<br />
<br />
Thank you.<br />
<br />

</div>


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.



<div>
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,<br />
<br />
mx
</div>


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

<div>
<div class="content wysiwyg-content">
I have a tabular form which displays a matrix of values. <br />
<br />
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.<br />
<br />
Thanks.
</div>
</div>


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.

MS Access VBA - Advanced Tabular Forms

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.