Help with DLOOKUP

[mpmoore]

It's me again. Today's dilema concerns looking up data in another table and then acting on it depending on what the information is. This will sound familiar to some as it is based on an earlier question. (thread702-81848)
[DealerName] is a field in the Lease_Table.
[Automotive] is a field in the Dealer_Table.

When the name of a dealer is entered in Lease_Table![Dealername], I need to return the value of Dealer_Table![Automotive] and run an If/Then statement based on value returned. DLOOKUP was suggested as a method to try, however I don't seem to be able to pull it all together.

Can someone point me in the right direction? s-)

Thanks,
Michael

 

[Aivars]

Hi!

strSQL="Select * From Dealer_Table Where Dealername = " & Me.MyDealernameUpdateControlInTheForm & ";"

Me.RecordSource= strSQL (main form RecordSource)
or
Me.MySubForm.Form.RecordSource= strSQL (sub form RecordSource)
or
Me.cboMyCombo.RowSource = strSQL (combo box RowSource )
or etc.

Aivars