Multiple text boxes on an access form: updating.

[drhenry]

I have an Access form that pulls up user records via a select query. In another table, I have fields that have a corresponding value that I want to display. However, there are 20 unique values per the select query records, and 5 possible values in the secondary table, which I need to walk thru in order to display the correct value in the form. I can't use SELECTFOCUS, because there will be 20 text boxes on the form. And using a select query to extract the corresponding values for the form will require a HUGE amount of tedious AND/ORing in the criteria box. Anyone have an idea?

 

[gcole]

Use vbscripting to assign the value to each of your text boxes (textbox1.value = variable). It sounds like you have to do a little programming on this one.