VB ver 6 – (Access database)
The first Text box input selects records in Table A that will be processed in a sequential manner (The input sets up the Select of the records and the start of the process controlling loop).
Each Table A record is then used to access a record in Table B which I need to update with some input data via screen input.
Can I use a Text box for the input data for Table B or is InputBox my only option?
This is a solution for some old fashion heads down data entry. So the least amount of mouse activity is favorable. The data entry processing should be 1) select the controlling factor (Table A) , 2) let the loop processing present the corresponding record in Table B for update, 3) enter the update and press enter.
Need some ideas and guidance. Got everything done up to the point of the data entry. Just don't know what way to go.
Thanks in advance…
Gary
The first Text box input selects records in Table A that will be processed in a sequential manner (The input sets up the Select of the records and the start of the process controlling loop).
Each Table A record is then used to access a record in Table B which I need to update with some input data via screen input.
Can I use a Text box for the input data for Table B or is InputBox my only option?
This is a solution for some old fashion heads down data entry. So the least amount of mouse activity is favorable. The data entry processing should be 1) select the controlling factor (Table A) , 2) let the loop processing present the corresponding record in Table B for update, 3) enter the update and press enter.
Need some ideas and guidance. Got everything done up to the point of the data entry. Just don't know what way to go.
Thanks in advance…
Gary
