searching a query using combo boxes

[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.

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

[Phil Stanton]

May I suggest a different approach
A Table of Matches MatchID, MatchName, MatchDate, Team1ID, Team1Score,
Team2ID, Team2Score SeasonID

A table of Teams TeamID, TeamName

A table of Seasons SeasonID, SeasonName

You create the matches on a form using combo boxes to select the 2 teams
and the seasons and enter the scores

You have a second form for teams, and a subform for the other team, and
scores.

Try to avoid DLookups. There is a limit to the number of open queries you
can run, and this query seems to remain open

HTH

Phil

"Cillies" <le*@prologic.ie> wrote in message
news:ba**************************@posting.google.c om...

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.

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