W
WildlyHarry
I have a form where I want to display specific fields from a query on one
continuious form. For example, I want to display the record in row 1, column
1 of my query in text box 1, and the records from row 2, column 1 in text box
2, and so on in that manner. I am placing VBA behind the text boxes,
specific to the values in those boxes, therefore a dropdown and a subform
will not work. I am currently using the dlookup method and it returns the
record from the first row of the query. Is there anyway to specify the
dlookup to return the value in the second row? Or is there some other method
that I should consider? Thanks in advance.
continuious form. For example, I want to display the record in row 1, column
1 of my query in text box 1, and the records from row 2, column 1 in text box
2, and so on in that manner. I am placing VBA behind the text boxes,
specific to the values in those boxes, therefore a dropdown and a subform
will not work. I am currently using the dlookup method and it returns the
record from the first row of the query. Is there anyway to specify the
dlookup to return the value in the second row? Or is there some other method
that I should consider? Thanks in advance.