I have a master form and a subform. The master form has a combo box that's unbounded (Unit Number) based on a query - and a series of text boxes that are filled in from an AfterUpdate [Event Procedure] that looks like the code below. This data is just for verification purposes only for the end user. This took me 2 days to figure out how to automate the text boxes from the combo. Bare with me.
Now I want to add a SubForm that will bring up only the data (Date of Record, Meter Reading, Comments) that corresponds to the value in the Combo Box (Unit Number). The user should simply type in a unit number, hit enter, and it should bring him down to the next open slot in the subform. I want the end user to type in the next meter reading in the subform and simply hit enter again repeat the process. Any suggestions?
Well I didn't respond the first time because I cannot identify what problem you are having, so I have nothing to say.
This time round, it's the same, but just so you know that most users will dodge this because (a) it is still difficult to determine what the problem is and (b) you seem to be doing some completely unorthodox things.
All I can suggest is that there is most likely a simpler way to do whatever it is that you are trying to do.