Hi, I have a form in which I have a combo box in which if a user selects
"Yes", the corresponding text box becomes visible and the default value
(which was set up at the table level) reads "Enter details here".  If the
combo box selection is "No", then the box goes away, which is ...

How do I synchronize a condo box with the rest of my form?  It is the primary
key and is used for Client Name.  When I pick a client from the drop down
list, the corresponding information for that client does not change.

I've had a frontend/backend system going at a notforprofit for about 5 years.
I've made no recent code changes.  I was called in last night because they
got a 'gray screen' when they tried to open an input form on a returning
client or merely to look at data on a current or previous ...

I have a form with 2 subforms in it... Subform A has a record source that is
a totals query.  Within the detail section of Subform A the Amount field
correctly displays the currency value, for example 123.45.  Within the form
footer I have an expression = sum([Amount])... the ...

I already have a form created.  I have about 19 tab pages on the form.  I
would like to use a different record source table for each tab page.  How can
I do this?

I'm feeling pretty dopey here.   I want to open a switchboard form maximized.
I searched for that and found out that in the VBA code page behind the Form's
Open event,  I can put the code:
DoCmd.Maximize

I have a combo box that I use to select a record on a form and I want to have
a text box show a certain field when that record is selected. How can I link
the two boxes together?

In Access 2003 with all updates including the reference to SP 8.  

Why does Me.FieldName = Ucase(Me.FieldName) in the after update event not
work when the format of the texbox in a form is set for long date? How can I
capitilize a long date in a textbox on a form?

I have added a number of records to a table with an update query, but i can't
seem to get my form to reflect those changes. How do i update or refresh my
form so that i can access the new records in my adjoining table?

I have a subform in a subform on a main form. The query that supplies the
lower level subform gets one of its criteria from a toggle on the same
subform. All works great except when i accidentally scroll the wheel on my
mouse. I then get asked for the criteria that should be ...

I'm using the following filter in a form "[OLP Call Date] = #05/07/2005#" and
all date formats are set to UK.  However the results show data for the 7th
May 2005.  How do I get them to show the 5th July 2005

I want to do simply this in MS Access.
PARAMETERS pTableName;
SELECT * FROM pTableName;
This doesn't work ( if it did I wouldn't ask you :) ) but is it clear

Help !!
Sorry if this is probably a bit basic, I'm a novice at Access I'm afraid.
Anyway...I have been tasked with adding a form to a table which lives in a
large(ish) relational database.

All-
I have been struggling with the need to turn off the mouse wheel so that
users are only able to add a single record to a form.  I know there is an
add-in or something you can download to turn the mouse wheel off, but the