Next Record from Query Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have got the results from a query, I have transferred the data from the
query results page to my form by using [Forms]![FindPtResults]![Surname] but
how can I get the data from the next record in the results.
I.e. Record 1 Surname is Tester, Record 2 Surname is Testing

but if I use the above in the second text box on myt form I get tester in
both, what am I missing to make it look in the next record, I have tried
typing GoToNextRecord but it doesnt work!! HELP!!
 
You need to revise your table structure.

Why do you not have Tester and Testing in the same record?
 
Back
Top