Changing a TxtBox to a check box or similar, based on a field in Db (1 Viewer)

[cclambie]

Hi.

I have

Form with 3 list boxes.
1st LB populates 2nd etc.

The 3rd LB value chooses a field.
The Fieldname Table has field "Field Type"

I want to change the Text box next to the List box to this entry in the Db.

Ie. If I choose a field in the LB, say "Done?", then to update that field it needs to offer me a "yes/no" field type
Therefore it changes the TextBox to a Checkbox (or combo with Yes and No as options)

Any ideas?

 

[llkhoutx]

Identify the (first) row selected in the first listbox, use the index field in that row as a filter for the second list box and requery the second lsit box. Do the same with the second and third list boxes.

 

[cclambie]

Thanks so much!

I have done!