I am using MS Access 2003.  I am building a form through the use of the
wizard to combine 2+ table on one form without using child forms.  If there
is a way to build it w/o using the wizard I would love it but for now the
wizard works.  Once I got the form complete I realized I ...

I have a form with a subform.
I would like to have the sum of a field from the subform on the form.
I was thinking of:
DSum("[Quantity]";"sales")

I've been working on filtering a form based on data contained in a
subform.  I got some code from Allen Browne's site
(http://allenbrowne.com/tips.html), but I haven't been able to get it
to do exactly what I need yet.

Hi Groupies
I am in wwwaaaaayyyyyy over my head on this one.
I have adopted a database that has extensive VB code. I need to set up a
Public or Global Variable, I am not sure which I need and I do not

I have a form with a variety of controls including text boxes, list boxes,
option button and command buttons.  The data entry routine typically moves
from control to control like: List box->Option
Button->OptionButton->CommandButton->list box. When I click the command

I have a subform (ECSFinancials) that is embedded in the MasterForm in
Datasheet view. It lists payments made on a file (ECSIndemnity). I want to
tally those payments on my MasterForm and either get the total for all the
files or the most recent payment on a file. If there are no ...

how do I print a form for someone to input data on.  I have one that is ready
for use with my table, actually input all of last year's info from old forms
this way.  I have no idea.  Should I drop the source for the form to nothing
if it allows me to so I can print out the forms ...

I have this on the Form_Unload event.  What I want if both conditions are
true then ask the question.  But if one or both of these conditions are true
then just close.  I have tried the 3 condition below and none are working.
Can someone help me as to why it won't listen to me?

If I have a 5 child and a parent table which are connected with an
FK/PK relationship.
I want a tabbed form the first part for the parent and the second for
the child.

I have a field in a form that I only want a user to input information in if
another field is not null.  Does anyone know how?

When my report load i want to ask from user:
Enter Starting Date: Date1
Enter Ending Date: Date2
and on the basis of these two dates i want to run my report (rptsmry)

I have a tabed table the first tab is the parent to the other five
child subforms.  How do I set up a single record view on the five child
subforms?
Can I remove the FK id number control from the subforms for simplisity?

My database uses switchboard buttons, which are driven by queries, macros or
codes.
My CURRENT POSITION: Example, right now to generate a report, I click on the
EXPENSE REPORTS button, it prompts me for START DATE, I input and press OK.

I am using Access 2003, and when I search in my form for numbers in any
field, the computer times out. When I search for any alpha characters, I get
a response
(I find what I searched for). I have searched for numbers in different

I have a form with simple buttons and labels ...can the form be configured so
that I don't have the left record indicator arrow or the bottom record
indicator so it appears as a simple box with command buttons?.  Also, is
there a way to make sure that it is always visible and not ...