In Access 2002, I have a form with multiple tabs. When the user clicks the
tab's label, I want an event to fire. Unfortunately, the tab's OnClick event
only fires when the BODY of the tabbed page is clicked. How can I make
something happen when the tab's title is clicked, as that ...

i have a combobox cboFindPatient that finds & displays the record. If the
patient is not in the list, i want the user to add data by using "add new
patient" button. (which works! thanks to the wisdom & kindness of the message
group)

I want to be able to conditionally disable a field in a record of a
continuous form. I see where it can be done with "conditional formatting" on
the "format" menu tab. However, the data becomes difficult to read when it is
disabled. Can I change the background color or font color ...

Hi everybody! I am trying to multi select in a list box but i get this error
message:
The field <name> cannot contain a Null value because the Required property
for this field is set to True. Enter a value in this field. (Error 3314)

I'm getting the error "The OpenForm action was canceled" when I click
on the button to open a form.  When I try to open the form in the
database window I get the following error:
"The expression On Open you entered as the event property setting

I have the date that a person starts work. I have been asked if I can get it
so the form can tell the user in months how long the person has been working
here. Can I do this?
Access 2003

I'm trying to filter a report by using a combo box on a form.  The
source of the report is a query (qry_ReportData) and the query uses the
combo boxes as criteria.  The row source for each combo box is a table
of employee names and a separate table of machine names.  I'm trying to

I'm guessing this is probably simple.
I have a form called frmWklyTrackingOptions that displays four command
buttons. Each button opens a different report. What I'd like to do is add
some code to the OnClick Event so that in addition to opening the report it

Help
i have a main form with a subform that contains data that i want to search
and goto a specific record. i created a combo find box through the wizard on
a form based on the table that creates my subform and then tried copying and

In my InvoiceRegister Main form I have a field for "Number of Invoices" , and
in the subform I will creat a record for each invoice. so what I want is , to
make sure that the number of records in the subform equals the Number of
invoices .

I have a combo box on the main form.  After update of this, I would like the
focus of the cursor to move to a specific field in the subform.  I've been
trying various different .setfocus combinations with no success.
e.g. forms!frmMain!frmTimesheetInputSub!ElementCode.SetFocus

I have two forms (they are separate forms).  One is a calendar (it has to
remain separate).  Here is my problem.  When I click my calendar, the clicked
date is entered into a control on my second form.  When this happens, I want
something else entered into another control on my ...

hi, can u help me how to filter reports using several criteria in a FORM..
i am using comboboxes and checkboxes to filter my report.  My problem is
when it comes to checkboxes.  
example:

I'm using a form with a combo box that has various companies listed. When I
click on the company I would like the information about the company to fill
in the text boxes I have labeled for the company name, address, etc.. Can
anyone help point me in the right direction?

I have a date control on my form.  When the form is opened, I want this
control to display the next scheduled workday.  I tried (control) = Date +1,
but could not get this to work.  Can someone point out what I'm doing wrong?  
Thanks...