By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,175 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,175 IT Pros & Developers. It's quick & easy.

searching a query using combo boxes

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.