Is it possible to create a combo box which changes the other fields
according to the selection made in combo box on a form.
For example, if user selects 'Monitor', other fields such as 'flat
screen/CRT?' would appear. However, if user selects 'Mouse', the previous

Could anyone please tell me how to produce a snapshot view of a form so that
I can email it. I can do it for a report but not a form.
Many thanks
JM

I am a fairly new user to vba in access.
I am trying to create a form that will send the contents of two textboxes
using outlook.  this i have done succesfully for one recipient.
the next task i have is to now send the e-mail to multiple recipients

I've received this error message that i have never seen before and I can't
get into my database. At times when it does let me in all of the tables have
dissappeared.
I:\NEWSUR~\SECURE~1.MDB isn't an index in this table. Look in the Indexes

I have a form with a Combo box named cboChurchName.  The user can change the
value in the combo box (which is bound to a table). Below the combo box
there is a button named Church Info.  Currently the Church Info command
button opens a form generated from a query named ...

Please help!  I have a limited knowledge of VBA, so please make this a simple
as possible.  Thanks in advance.
I have 2 questions:
1. I have a form called Parts Lookup with a combo box called cboPartName.  I

I have form that is designed to open in DataSheet Format.. When I open the
form normally it works perfectlhy.
When I open it from switchboard open form in add mode it open in form
view...  

I have a subform which is a datasheet. When a user clicks on a row in the
datasheet I want the record on the main form to update and display those
details.
If I have the following code executing on an on_click event I get an out of

I want to create a database which has several forms in it but with only a
few fields in each and linking in between by command buttons.....here is what
I need
First form - details are entered in each field

 I have a control "txtMin" in the header of a form and the continuous form
has a list of values ...  I have conditional formatting setup to change the
background color of 'txtSOS" to blue if it matches the txtMin control.  It
does not work.  txtMin is setup to:  Min([SOS]) and ...

2 serious problems i encounter . Any help will be wellcomed
11.  I had a report based on a table.We decided to cancel 4 fields
from tableand I removed them from report and changed the table qury on
report - I checked the sql - everything looks fine. However when

 I have a from that I want to filter by the valu eof a text box but the
form keeps prompting me for the text box value upon loading...  Here is the
SQL
SELECT tblSpeedOfService.SOSID, tblSpeedOfService.SOSDate,

The problem:
    I have date tequairing almost 450 separate fields and have
created 3 tables to deal with this.
the problem is linkin the 3 fields together.

I am using MS Access 2003. (FWIW, this is about an ADP project, not
MDB.)
A form has a variable that is initialized (by some function call) in
Form_Load() and then stays unchanged for the form's entire lifetime.

Is there a way to draw lines across a Form or Report? I want more visible
section dividers in forms, and do not want to have to import graphics from
outside Access. I had a method for doing so in 2003, but am stymied by 2007.