I have a form called frmRelations on this form I have a subform/subreport.
On the subform/subreport I have a subform called frm_Address. The link
between the 2 forms is oke.
On the subform I have a command button called cmdAddress and on the Mainform

I have a form with a Listbox that is filled by query
 SELECT ClassDesc FROM classcodes WHERE
Forms!Aclass.CODE=classcodes.code;
 Problem is ClassDesc is a memo field  and does not "warp"  when

I have a form which has two subforms. The subforms are populated from
queries which are based on a 4 tables. On my main form I have a control
"Total Expenses2" that is populated from the value of a control on one of my
subforms using this as the control source

Access 2000
After working in design view of a form, I close and save the form and
are returned to the list of forms in the Database Window.  For quite
some time (30 secs to 1 minute), I cannot select anything in the forms

I am having a problem today;
I have this code  in "Before Update" on form field ftxtCCard
Public Function CCVSModuleWindowCCNumberTester()
   Dim CCVSAnswer As Boolean

some of my word files giving this message MS word showing Data Error47 of 94
93 F4 K5

I put a combo box in my form as the input data.
How to restricted the input data base to the data
listed in the combo box only,so that if somebody
try to input data which are not listed in combo box,

I have an option group that originally had 2 choices. (These choice relate to
which report will be run.) I wanted to add another report (and therefore
another button to the option group) but I couldn't figure out how to do it. I
wound up deleting the option group with two choices ...

Hi, I have a form named Invoice_frm used to create invoices. Our client
wants a duplicate form named Proforma_frm. The only difference between
the two is that the Proforma_frm adds a PF in front of the invoice
number (ex. PF8310). I've made a copy of the Invoice_frm and everything

I have an Invoice frm (& tbl) and I want to allow the user to enter an
invoice # and select a vendor from a cboVendor. But if that Vendor and
Invoice# combination already exist; then display msg.
Simply put, how do I prevent entering a duplicate invoice from th same

I searched the community and found no solution to the problem I am
having.... please help.
I have a form for assessment. Each line item has a default level of risk. A
user enters the level of importance and a grade is given. Currently, the

I have a main form with a subform.  The subform is based on [query_sub].  I
created a combobox [combo12] in the main form and made one of the where
clauses in [query_sub] equal to [mainform].[combo12].  All worked well except
it won't update when the choice in the combobox was ...

When I maximize the main form, all forms are maximized.
I just need to have the first form (a search form) maximized and all other
subsequent forms not maximized (normal window).  
How do I accomplish this?

I am creating a form that has a Tab Control with multiple pages on it.
All of the pages contain different ways that users can select the
records they need. What I realized is that I need a way of getting a
count of all the pages that have selection criteria entered on them.

I have a Mainform called "MainPastDue" and a Subform called "PastDues".
Currently when the user logs in they open the Mainform and click on an
Option button and a combo box appears where they can select their name
and it will filter the data in the subform based on there name.