DLookUp

[Cillies]

Hi!
I have a form that displays information using DLookUp.
Now at present I am going into the query and entering criteria that I want the form to display.

i.e. the form is for a sports team and I will enter in the team I want to display and the season I want displayed. therfore recieving the results of the team that played on the selected season.

Now I want to use a form to call the results form using drop down boxes. But I don't know how to manipulate the DLookUp. Can anyone offer me any advice on this.

Thanks

 

[Cillies]

Here is a sample of the code on my results form

=Trim("Team Selected Against " & DLookUp("[Opponents]","Search By Opponent1") & " on " & DLookUp("[Date]","Search By Opponent1"))


Thanks

 

[SJMcAbney]

=DLookup("FieldName", "TableName", "CriteriaField = " & Me.MyCombobox & ")


Cillies, be aware that Date is a reserved word in Access.

Stewart J. McAbney | Talk History