Hi, please help.
I'm new to programming. I have a form with a standard amount of buttons
created on it (40 buttons). I would like the caption property of the buttons
to be setup when the form is loaded. The caption values will be captured in a

I'm trying to load a text box on a subform with the information in a text box
on the main form.  I can't seem to get it to work as I get the error message
that the subform can't be found.
I've tried using these pieces of code but they don't work.

Well I'm feeling a little braindead at present.
Just goes to show, a little time away from access is not always a good
thing.
Now I know I can't link an unbound control, so can anyone outline the steps

I have a form with one regular subform and then another subform that, in turn
has two subforms of its own.  I can easily filter the three subforms using
code, but when I try to clear the filter using the code below, I run into
problems:

Perhaps its due to my lack of sleep with my new
puppy but I just can't get my head around this...
I have the following in my forms on open
event to determine shift time:

Hi,
I have a form that has search criteria and results.  I have a field that is
unique to each record, containing a 6 digit code.  I need to create a text
box field with an "apply filter" button on the form that would allow users to

I am trying to add a new record to a table using a form.  Everything looks
fine until the code hits frs.update.  I then get the following error:
"Cannot add or change record because a related record is required in table
..."

Looking to update multiple records based on what the user selects from a cbo
on a form that will influence the subset of records in the subform.
If user selects a condition from cboPupStatus on the main form in which all
the subset records are tied by the same record number which ...

I am fairly comfortably around standard nested queries, but I get in a world
of hurt when it comes to QueryDef's.
Can anyone assist with structuring the following please.
Private Sub CmdBtnNSW_Click()

Thanks for taking the time to help.
I have values in two text boxes, Me.CALL and txt.LastCall.
The values in both boxes are separated with a forward slash.
For example, WCCC/WDDD/WEEE is in txt.CALL and

I have a Net Form that records the transactions of the customers.
Date              Debit                Credit               Net
1/1                 10                                           10
1/2                                          -15                 -5

At first sorry for my poor English, I'm speeking and writing not often the
language.
I have a table of archer-competitions, and I have a table of categories
(archery). I have a form, with a combo-box, where I can choose one of the

I learn that there is compiled version mde file for client app.
What are difference between to distribute mdb or mde to end users?
Your information is great appreciated,

I used your example on a running sum that I am working on.  The problem I
have is that I'm trying to run a sum on my "previous" invoices only.  The
problem I have, using your example:
Subtotal: DSum("[Payment]", "[YourTableName]", "[FleetNo] = " &

It's strange.
Dcount formula return incorrect result if I define
where condition on open form even.I have some code
on click even of cmd_OK button.The code is :