Can anyone help with updating two controls on a form where each gets it's
default value from a separate form?  I can get each to work separately, but
can't get them to work together.  I set this up in a macro, but here is the
converted module:

I was looking in on answer a question without you guys help, SHAME ON ME!!!  
I discovered the bug where, using the close button DoCmd.Close, does not save
if required fields are left empty.
I found an answer in the forum that led me to Microsoft's site.  Microsoft

I have form where datasheet is the default view and 'allow form view' is set
to 'no'.  Still,I get the form in 'form view' when I call is.  Can someone
help

My user would like to add a new record to a continuous form at the TOP of the
form.  
I understand this can't be done, so I created a separate form above it for
new records only. (allows add records, not deletes or edits).  It works fine,

I have a form into which community nurses enter details of patient
contacts.
On this form (based around a table called VISITS) I have two
comboboxes. Both draw their data from the same table (CCN) which are

Hi everyone. I have a problem with the above subject. I need to make a
button on a form that will take a screenshot of the current form and send
to to the address mentioned in other fields. So far, I've been able to find
this code to, but can't get it to work (there is some error ...

I have a form where the bottom half of it is only relevant if the value of a
combo box above is "son" or "daughter."  Is there any way I can set the
fields in the bottom half of the form to be either greyed-out or not appear
by default, and then activate when the value entered in ...

I have a form that allows users to add/edit records into a table called
LabTests.  The number of records is starting to get long.  What we want to do
is to start archiving records.  Everything that is greater than a month old
and has a value in the CheckNumber field would be good ...

The following sets the subform recordset to nothing and works when the
parent is on an existing record but fails when the parent is on a new
record - which happens after the last record is deleted:
Me.cfProgram.Form.RecordSource = ""

I am following precisely the Help instructions for "Find a Record by
selecting a value from a list." I am trying to find a record by entering a
number in the combo box that is also  in a designated field in the source
table. But I keep getting an error message, saying there is no ...

Using Access 2000.  I have looked on the web and it's probably not possible
but I'll ask in here anyway because the data entry person would really like
this to be the way she enters this particular data.  I have a form based on
a crosstab query, I sure wish there was a way to ...

ACCESS 2000
I have a database that contains 70+ employees and I am looking to structure
my forms in a manner that would show the list of employees at the top of the
screen, and if you click on the name or button next to their name, it would

I would like to create a form and subform that have a 1 to many relationship.
Can bot of them be made input capable.  
So far all I can see in Access documentation is that the sub-form is Output
Only ALWAYS?

I tried using, in form design view, a DateSerial funtion to caculate a future
date which is ten days later from a starting date of 4/2/05.  I set the
format property for the Startdate text box to short date and the control
source property for the future date to the following:

I have a combo box (on EntryForm form) that is working fine retrieving data
from a table (Materials). My problem is that when new data is entered, the
user cannot  select the new word in the combo box unless that form has been
closed and reopened. The result is that the user has ...