I have searched help and MS site but just haven't found what I am looking
for.  I have a form that has a back color and it gets printed quite often.  
How can I keep the color for view but add code before it prints to have the
color go to white?

This should be simple?....
I want to take the text selected in a combo box, after update, and use the
text to make another field visible.  Like this:
Dim ctlGrpLvl1 As ???

I have a form (frmOcccurance) that has several subforms.  I am trying to move
the focus from the field 'Contact' of the subform (sfmContacts) to the field
'CorrIndv' of the subform (sfmCorrections) when there is nothing typed into
the field 'Contact'.  

How can I use automation to get PP to open an existing presentation and
start from say, Slide 3 of 8 ?
Code like
oPres.Slideshowsettings.Run

I have a field on a continuous form that references a lookup table (the field
stores only the numeric values that correspond to text values in a linked
table).
However, the user finds it easier to select these values using a checkbox on

I am having trouble getting this code to do what I want. I am using the
following code to loop through an unbound list box and do a multi remove.
All it does is remove the first item of the multi-selected items, but I want
all the multi-selected items to be removed. I'd also like to ...

ACCESS 2000
On my switchboard I have 3 standard Command Buttons, and one of the buttons
is CLOSE SWITCHBOARD; this button closes the switchboard but the file is
still open, and it is for top level users to go into the database and make

I am importing worksheets into a ms access database model.  I have had
occasions where users have deleted the worksheets, moved them, etc.  I would
like to to test for their existance before I run my import routines.  How
would i write that?

I have a form (A) and in that form I want to have a control that will open a
data entry form(B). Every time I try code or a macro it takes me back to my
first record on the data entry form no matter what record I am on in form (A).
I cannot get these 2 forms to be linked together. ...

I've done a search for saving unbound combo boxes and also how to refer
to values for dependent cbo boxes, but I couldn't find anything that I
could put together for what I'm trying to do.  I'm so confused, I hope
I get the across the way I want it.

what do I need to do to make it so, when I open this form, it automatically
goes to the next entry screen AFTER the last used ? or even to the last  
entry would be nice.
Also, is there a place I can go to "learn" how to put my ideas to work in

Anyone have a reference to customize a switchboard? I want to display
different graphics based on the current "page". Example:
When the "Main Dish" is selected, display the "Main Dish" image
When the "Desserts" button is selected, display the "Desserts" image etc

I'm working with Access 2003
I have captions on on of my forms. As one of the features of new Access 2003
(caption is flicking when is not connected to any form) i had to connect
each caption to other control, such as Textbox or combobox.

Re Access XP - method for locating desired record:
I have an unbound field in a continuous form where the user types the first
few letters of the last name and presses enter.
Then the following code brings the user to that record:

If I have two tables, each containing "user_ID" as the primary key, what
code do I need to write so that when I populate the "user_ID" in one, will
it automatically populate the other?
One table contains basic user information (name, address, phone#, etc.), the