I was the one who helped you a while ago. You have code behind the
following forms:
Switchboard.
frmSelectArtist
and Artist Form
The one I helped you with is the frmSelectArtist. The switchboard
opens frmSelectArtist. The combo box is an unbound combo box which
populated by a query that is stored in the properties of the combo
box. When you click the command button it opens the report called
ByArtist
The recordsource of the report uses the Query called Artist. The
combo box called is used as the criteria of the Artist 1, 2, 3, 4,
and 5 fields. [Forms]![frmSelectArtist].[cboArtist]
Not knowing exactly what you are attempting to do, but I suspect that
you need to setup your query so that your report filters for you based
on the values you select in a combo box.
Hope that helps get you going.
Dawn Crosier
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and
questions to the newsgroup so that others can learn as well.
----- Original Message -----
From: "Garry" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, April 29, 2006 12:45 PM
Subject: [ms_access] Code Help
i recently got some very good help from one of our members here on a
Comic Book database I was putting together.
Now I want to create another command button on one of my switchboards
that is similar to the one she helped me with.
I want to copy and edit the code from the first button, but I'm having
trouble now even finding the code. I know I looked at it and changed
it before. But now all I seem to be able to find is some very simple
basic code and not the explicit instructions. I know I'm probably
just not looking in the right way.
Could someone please help me out?
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
