I'm trying to create a document (letter) wherein Form field (Date) would  
automatically update based on the manual entering of information, i.e., if I
typed in a date in one section of the letter, the date in another section
would auto calculte to 60 days later.

In some VBA code behind a form, I issue a DoCmd.OpenReport to print
(AcViewNormal) a report.  At some points, it almost appears as if the VBA
code (in the form) regains control even before the report program completes.
I'm not concerned about whether the report physically prints, ...

I have two Check Boxes on a form. When the form loads I want one of
the Check Boxes to be selected by default.
I added this code to my Form_Load() sub:
   Me.chkALL.Value = True

I have a form (header) with a subform (lines) linked to each other by four
fields.
My problem is when I need to change one field in the form (header)
automatically the record in the subform disapears.

Access 2003 SP3
Win XP SP2
Using Allen Browne's tutorial ( http://allenbrowne.com/casu-23.html ), I
have set up a form with a subform that populates a combo table using a combo

Guys, I need help on how do I pass information from my Listbox to another
form via double click envent.
?

Is it possible to ask a form which control currently has the focus?
Chrisso

I need to output my list box results in a form to exce without creating a
query to do it.  Could someone critique this or give me another sample?
DoCmd.OutputTo acQuery, ([Forms]![customers]), acFormatXLS, "*.xls", True
The list box name is lstCust and it is new customer information ...

I have a sub form that has a text box , and if you enter a number in it
[OTDLhoursused] it is tobe catagorized by selecting one of four radio button  
in a radio button frame [Frame 40] holding 5 radio button. The number is
entered but sometime the radio button in not selected , ...

This could be confusing!
I have a couple of pop up forms that appear when I click on a button
to add pricing for a specific customer and for a specific item. This
would be a discount from a list price. The first form is okay I think.

In Paradox I could link a lookup table to a form so that if I entered the Zip
Code, the City and State name would come up. Can I do this in Access?

The following is the row source content of both combo boxes.
SELECT DISTINCT tblMaterialMaster.LocalGroup
FROM tblMaterialMaster;
SELECT DISTINCT tblMaterialMaster.LocalSubGroup,

when you are creating a report and you want to print 2 dif var like
This is only a test  "txtfield1" "txtfield2"
they will print the length complete of the field and the second one start
after that

I would like to change the forecolor of a combobox depending on which option
is selected.  The combobox is populated by a lookup table with an inidex
field.
ie. option 0 = closed - combobox.forecolor = 0

Hey there.
I've been experimenting with using a shared recordset object so that the
various subforms in my app will be linked to some degree.  It works fine
until a sort button is pressed.  When this happens, one subform will be