Next Record from Query Results

A

Ambu-Al

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!!
 
K

KARL DEWEY

You need to revise your table structure.

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