I have a form that I can select a value from a table and it inserts the
value into the master table. I need to be able to display a value in the form
based on the selection.  The field that you can select to add to the students
record is a college.  I need to then display the ...

Can you have multiple expressions in a control source?
I have a control source expression:  =IIf([Action]="Internal
Review",[Start]).  I works very well,  But at the same time, I will have
multiple records for "Internal Review".  When I open the report, there's alot

I created a database to track our orders. I have a order detail form (&
table) and a purchase order form (& table). I have the order detail form as a
sub form on the purchase order table.
The order detail table has a product combo box in it, now when i am in the

I have a form with a Listbox, when I click on this listbox it opens
another form with a group of records.  This works fine.  The problem is
that I have 2 criteria, MenuID and MenuCatID.  If I keep the 2 criteria
it only brings up 1 record and I cn't cycle through theother records ...

For simplicity sake i have a table with a multitude of of fields like, item,
week, store, etc. all.  The users that will be searching for data are not
very savvy when it comes to teaching them new software.  Showing them queries
has become a difficult.  Bear in mind, i am no ...

I have developed a Visual Basic program that uses the Snapshot Viewer Control
(SNAPVIEW.OCX).  The data was exported from an Access report into a .snp
file.  I have two questions:
1)  I am using the PrintSnapshot method to print the reports.  Is the some

I have a table: tblTemplates with two fields TemplateName and Template.
text field     memo field
TEMPLATENAME   TEMPLATE
------------   --------

I have designed a database in Access 97.  It includes a report switchboard on
which I can select the report (via checkboxes) I want to print.  It also has
a combo box and other items which are either visible or not vislbie,
depending upon the report selected (by using a macro ...

Is there any way to navigate through a continuous form without using the tab
key.  My form is set up with 10 fields, but some records may only require 2
fields.  Is there a way for the user to go to the next record without tabbing
through the unused fields?

I am trying to aadd records to a many to many relationship.
I have these tables:
Vehicles (Primary Key VRM)
Drivers (Primary Key DriverID

On a form I want to display a price field in bold if it is zero.
I have tried the following code in the AfterUpdate event of the field but
have found that the prices on all the displayed records change to bold not
just the one that is zero.

I did it many times but now I forgot it and cannot open a form for a specific
value.
There was a method that create the following code automatically.  We can
match the values and even determine the picture or text on the toggle button

I am trying to use animated icon buttons.
When i set one up (Which works ok) and I click the button, it indicates that
u can do soemthing with it.
BUT there is no 'on click' event and none of the otehr events seem to let me

Im not sure which newsgroup is the best place to ask this.  Im trying to
create Outlook Express Style toolbars for use in my Access application.  Im
not sure if using a form to simulate this or whether to use an actual
controlbar is best, ive tried doing both but cant get it to ...

Im tring to open a form(frmBusiness) from another form (frmAddress). Im using
a command button on the Address form which uses a macro action Open Form. The
data mode is left blank. The Where is set to [AddressID] = [Forms]!
[frmAddress]![AddressID]. The business form Edit and Add ...