Using Access '03, I have a main form, with a subform1 and a subform2 (nested
in this order).
I want to make a control on the main form sum up the values in a control on
subform2.

I have a form that has a few boxes that have an input mask on them so that
information is entered the way I want it entered e.g (uppercase) etc. However
if that requirement is not met and the user tries to tab out of the box they
get an error message that says: -

I double-click a control to bring up a small modal/popup Search Form. I need
to pass a value generated in the Search Form back to the initiating form (in
fact the control I double-clicked), when I close the Search Form.
How do I get the Search Form to know which form has called ...

I have a read-only control (InsuranceVale) on a tabbed sub-form that
references and displays the value that has been entered in a similarly named
control on my Main form. (Thanks to Arvin Meyer for helping with this).
If I enter a value on the Main form and then move to the ...

Hi
In my client table i have a field called suburb.  This field looks up the
suburb table to get its values.  In the Suburb table i have a suburb field
and Post code fields.

I am not a pro...hoping you can provide help.
My client entry form has a jobs subform and jobs has a details subform.  All
are set to data entry either by property or code.
As I enter data, if I do so in order of parent, sub1, and sub2 I get no

I am aware of the basic effect of Enabled yes/no on a control on a form, and
have used it to create read-only fields that pull values from other forms
just for info purposes.
But what are the differences, the pros and cons, between Enabled and Locked?

I created a database and set the table date fields to Medium date and
included an input mask for the medium date  99\->L<LL\-00;0;_  I created the
database on a computer that uses English settings. I installed the database
on a computer that must have french settings. The input ...

I have a Main form with an underlying table called Inquiries. This includes a
field called InsuranceValue.
I have several tabbed pages hanging off Main, with subforms handling various
details of each transaction.

I have a Master/Detail (form/subform) for Customer Invoices.  The
Master portion of the form contains the Customer info. Customer
number, customer name, resale number, and invoice number.  Some
customers have a resale number and some don't.

I am hoping someone can help.
What I want to do is have my forms show up with a drop down box
showing my client names and then when I select my client the form
should show all my accounts for that client.

My dbase has a form with a subform.  In the subform you enter the beginning
mileage and ending mileage of a vehicle every month (along with other
things).  How can I make it to where when I choose to add a new record (the
next month's data for a vehicle) that the ending mileage ...

I have two number fields. In the table I have the fields set up as decimal
and the format is general number with two decimal places. I have the same
format for the fields in the form, but everytime I try to put in a decimal
number the form automaticaly rounds it up to the nearest ...

I am familiar with how to change the colours of most items on a form in
Access 2000 but I have hit a problem with the component parts of certain
controls, e.g. scroll bars or the drop-down button of a combo box. So far, I
have not located any way to change these from the default ...

is there any way to do any kind of individual formatting of text with in a
label box? I have a large paragraph of text in a label box and I want to
make a few of the words BOLD. I tried doing the formatting in Word and then
pasteing that in but that did not work. I also tried ...