Filling in other textboxes with corresponding record data from query

[halt4814]

I have a query that selects records in a certain date range. Then I have a textbox that gets an input of the earliest date of that range... I used the code...

=DMin("<field name>","<query name>")

What I want to do is fill in other textboxes next to that one with the other fields' data for that corresponding record.

So for example, the query runs and outputs the data and part number 2123 was ordered 10/2/2012, which happens to be the earliest in that particular date range. So the one textbook does work and outputs "10/2/2012"...Now I want another textbox right beside it to output "2123". Any suggestions?

[June7]

Maybe:

=DLookup("partnumber", "queryname","datefield=#" & DMin("<field name>","<query name>") & "#")