Dlookup specific record

[lolosuarez87]

Hi. I want to autofill in a text box with reference to a table I have in Access.

I have the first text box that returns the first record in the table i want to get the data for with

"text1 = Dlookup("numplate", "cars", "")

This returns the first record.

I want the second text box to return the second number plate from the table.
How can I get the second record to be returned...?

Thanks.

 

[Galaxiom]

The order of records in a table cannot be defined by the way they appear when you open the table. You must have a field that can be used to determine an order.

You would need a condition as the third argument of the DLookup to select the record you want.

However I suspect you are going about this the wrong way and probably need a Continuous Form.

Explain more about your data and how you want it presented and we can give you some more advice.