Auto Select Field

[brsawvel]

Simple question for a silly program. Is there a way to and have two fields on a form automatically populate with a random field when a button is pushed?

I.e.

txtfld1 populates from a random field in column 1, tbl1
txtfld2 populates from a random field in column 2, tbl1

 

[John Big Booty]

I'm not quiet sure I understand exactly what it is you are trying to achieve. Perhaps you could explain exactly what it you want to do and the data that is to be displayed in the fields.