I have a form that has a subform.  Is there a way to "adjust" the dividing
line?  I don't necessarily need to get rid of it, I'd just like to adjust the
height.  For example, both my form and subform can fit nicely in one window,
however, with the dividing line, I need to use the ...

I have a main form with two sub forms on it.
The recordsource of the second subform has in it's criteria a reference to
the JobID of the first i.e. forms!MainForm!Subform1!JobID.  If I put a
button on the main form and requery Subform1 from it all is well - Subform2

I have a database for a small non-profit with a member list.  My NEW table
structure splits our member information into two tables: tblMailingList and
tblContacts.  Essentially this allows for multiple family members within a
household.

i have a table which is populated using a form. one of the fields is
person's name, the dropdown for which picks up data from a second table
(which has an index and person's name).
what i want to do is modify the form so that a user can select multiple

I am using Access 2003.  My switchboard is working great but was wondering if
there is a limit to the number of items I can put on one switchboard?  I
currently have 8.  Thanking you in advance.

I have a form that runs a 'Customer Address' query.
One Field in the query has address type ( Billing , Shipping etc .. )
I was tring to figure out if I could have on my form which a checkbox called
"billing" and another called "Shipping" and if the check box was checked the

May I get some help in programming on MS Access, the following code should
be inside a textbox in a form
=Sum("[small]";"table1")  >= Sum("[big]";"table2")
Example

I am new to Access and would like a simple way clearly explained on how I can
code the close button on my form to close with out saving the data that I
entered(not updated).  ie I am adding a new record and realize that I don't
want to add this record to my database so I want to ...

Please can you make it correct or if there is other way for RESULT2.
I convert  query to SQL and copy it to use on Visual Basic.
The code will be so:
RESULT2 =

I have a combo box with four columns:
[NameID]        [FirstName]        [Last Name]        [ FirstName] & " " &
[LastName]
Column #1 is the bound column and is hidden.

Hey, anybody know about a combobox that cannot be typed in but can be
changed SelectedIndex? I mean, user can choose the item, but cannot type in
the combobox itself? I don't remember its name. And can you give me some
sample about how to use it. Thanks a lot!

I have a subform with multiple fields that I keep in datasheet view.  the
last field is for notes is much wider than the form so there's a horizontal
scroll bar at the bottom of the form.  
When the user tabs to the Notes field it automatically moves the left margin

I've been used to using the .column property on a combo box to refer to the
other columns in the underlying data source; since using 2007 this doesn't
seem to work for me.
I put in the normal syntax and then Access goes and does this:

I am trying to influence the outcome of a subform through the use of a Combo
Box in te form, and the following statement;
SELECT Tenants.* FROM Tenants WHERE (((Tenants.[Moved
Out])=IIf([Period]="Current",Tenants.[Moved Out] Is Null,Tenants.[Moved

In design mode when the properties window is open for a form, you can click
on any control to see its properties.  In previous versions of Access, there
was an icon in the top left corner of the form to click to indicate you
wanted to select the form itself in the properties ...