DLookUp Help Needed

[cvegas]

I have a continious form that displays information about quotes we are
getting. I would like to display the lowest bid for each order on the form.

The table that stores the bid information is called dbo_tblBidHistory.

I would imagine for each Order I would have to go into this table and find
the lowest value associated with it's OrderID number and display that value.
I don't have a clue on how to accomplish this.

Writing it out it would say
Go into the "dbo_tblBidHistory" table and find the lowest "Bid" that we have
for "OrderID" = "whatever" and display that in a txtbox on the form.

There could be a dozen different "OrderId's" displayed on the form and I
would like to display the lowest bid associated with each "OrderID"

Any help would be appreciated.

Thanks in advance for any help you may be able to provide.

 

[JackL]

Try this:
Set the ControlSource property of your text box to:
=DMin("[Bid]", "dbo_tblBidHistory", "[OrderID] = 'whatever'")
Regards