I have a form the gets values from a combo box onto the main form, what I
want to do is now get these values into the main form records:
Private Sub Form_BeforeUpdate(Cancel As Integer)
   Me.txt3_rate = Me.Ctl3yrlease_rate

I have an form where as I mark 1 field: STATUS to "complete"; I want another
field: CompletedDate  to update to the current date.  
The Status field has several different conditions:  Complete, Cancelled, In
Work and once any of these are set the corresponding date field needs to

I have created a VBA procedure for a form intended to prevent the user *from
moving out of the current record* if the date entered in one field is not
more recent than the date entered in another field.
I initiate the procedure using the BeforeUpdate event for the form, and a

I have a form with service address and mailing address fields. How do I
automatically populate the mailing address fields with the service address
data already entered. Most of the time the addresses are the same.

how do I make the default value the value from another field. I tried the
default value option in the properties but it does not work.

When I use my form to add a new record, I get the following error:
"You tried to assign the Null value to a variable that isn't a Variant data
type. (Error 3162)"
The form opens fine, but as soon as I try to enter data in any control, this

I'm working in Access 2002 and have a form that has a list box.  I want the
field to be empty unless the user chooses something from the list box.  I
have set the default values in the table and on the form to be an empty
string ="".  I've tried putting in the equals sign and ...

I've built a DB with a form which is linked to an excel table and is shared
on the network (the table is outside the database)
when i open the form on one computer it works fine , when i try to open a
form on a nother user's computer it tells me that the database is locked.

Now I understand why storing a calculated field in a table is usually a
bad idea and you should just recalculate it later if needed.  I've read
about 10,000 posts asking this same question!!  However, I have a form
which lets the user choose a number of days from a pull-down combo ...

i use a launcher for input date period(from date ;to date)  and apply a
WhereCondition to another Form.
"(Date Between #" & FromDate & "# And #" & ToDate & "#)"
the problem is when this WhereCondition apply to the Form it will auto

I have a form with a combobox setup to find a record with combobox
selection.  When the form is opened, all the fields have information from
the first record but the combobox is empty?  Is there a way to populate the
combobox or have the form empty when opened then populate all ...

In a form, I have the control source as a calculation.  I need the value of
that calculation to be recorded in a table.  Is this possible?

I have 10 hot shot companies that I use.  I have a database that I use to
list the companies.  However is there a way I can design a form that would
keep them in order and display the next one up and keep them going in a
continuous order for each time I enter an order?

I am trying to create mailing labels from a database in Access 2000.  When I
go thru the wizard and get to the point where it is going to display the
form of labels a window comes up labeled Enter Parameter with area to enter
some value.  What parameter is this looking for.  I ...

Can anyone help with the following?
I have a Form that has a combo box (In the form header) that when a part
number in the combo box is selected then the detail in the form displays all
the specs associated with that part number. What I want is to have a field