Is there any way to call the "on current" event  of a parent form from a
subform? I don't want to "requery" the parent form, though, is that the only
way to have the "on current" event processed?

On the load event of a sub form, I am attempting to set a checkmark value
based on teh value of a checkmark on teh subform... I am getting an error
indicating that "you can't assign a value to this object". The checkbox
control  is not locked and is enabled.

Until I can normalize the data in my tables, I need to use
this command on my form:
Private Sub chkobsolete_AfterUpdate()
    If Me.chkObsolete Then

I need to capture a value selected in a drop down list and use it as a
criteria in a query for a report. asked differantly: How do I move that value
from the Drop down through the command button and into the query that
supports a report.

It seems to me that there is an incredible wealth of knowledge is these
newsgroups, something that no book I have seen can even come close to
matching.
So, if any of the Access guru's here have been thinking about writing their

have 4 combo boxes whos row source is dependant on the first 2.EG
CBOA   drives the rowsource for CBO B and CBOD
CBO B drive the Row source for CBOC
CBOA is on the main form   CBO B<C<D or on a subform

I am attempting to write a code so that when a command button is clicked, a
field in the form is automatically populated.
In the "On Click" event procedure, I want to have code that indicates the
following statement be entered into the field "Coverage Area":

I am having a problem doing the following -
I have a normal Access 2000 listbox control populated from a crosstab query
- the idea being that users can compare 2 sets of data side by side.
What I want to do is automatically move any items that don't match to

posted in a different group ... probably the wrong one
I send some retrieved records from access to word
   Set WD = CreateObject("Word.Document")
   templ = CurrentProject.Path & "\Invoice.dot"

hello, they taste when trying to recover the name of a mail from an
application VB, the attachaments name is of long 8 characters, being that the
name is a lot but I release, like it is possible to recover the complete
name.  Thank you.

Access 2002 user,
I have a data entry form where users frequently use Copy and Paste
functionality to populate text boxes on the form.
Users are copying a space before the text, and since I use these fields to

How do you call a macro in the code behind a command
button?
I tried doing it the same way I call other procedures, but
it doesn't work that way (just listing the name of the

Is there a simple way to count the number of records loaded into a subform?

Hi to all,
I have a form fsubC with two combo boxes on it, cbo1 and
cbo2. In cbo2 there is a third column "ParentID" with a
filter Forms!fsubC!cbo1.value used to filter the list of

i am using a combo box to display appointment times. what i would like to do
is when one of the appointment times is booked for a patient (say 9.15am) it
will no longer appear in the combo box so a double booking cant be made.
if anyone can help or point me i  the right direction ...