I need to set up a form where i need to be able to put in one field and have
access know which corresponding field goes with it.
For example i need to make an invoice where i need to be able to put in
things like "docket Number" and then a field called "Docket Total" (which are

I have created a VB custom control that lists the contents of a
directory. The directory path is in a Access database field.
If it is a single form or if I only use one custom control on the form
and set its Path property on Current event for example - it all works

I have a db where clients' medical appointments are
recorded. When appointments are entered, if the
combination of values in three fields
(clientid/date/provider) already exists, I'd like to

I'd like to be able to use a limited browser on my A2000 form that will take
users to a preset url when the form is opened.
Besides the ms WebBrowser ActiveX control, is there any non-activex
alternative ?

I have a continuous for with mutiple fields.  I have totals at the bottom of
the form which work as follows:
data fields:  XS, S, M, L (these are quantities).  Sometimes there is NO
value, example:  the customer only ordered M and L.

Hi - I have 2 combo boxes that I want to relate to each other.  I set up and
sql expression to base the value from one combo to the other.  It works fine
but if you want to revise your first combo choice the query doesn't reset.  
It always returns the value in the second combo.  ...

I have just started getting the following error message in my coding within a
form. When setting a variable to a text object on a form I get this message:
You can't reference a property or method for a contol unless the control has
the focus. Any ideas why I am getting this?

I used the Wizard to create a combo box to find a record. It made the
following code:
=========================================================
Private Sub CompanyCombo_AfterUpdate()

In Access 2000, the specification states that the Number of controls and
sections you can add over the lifetime of the form or report is 754. How can
I know if I have reached the limit? Is there any way to reset it (as by
making a copy of the form)?

Hi, I am using Access 2000.   I have set up a number of related tables.   The
main table contains look-up fields to the other tables.   When I view the
datasheet, I can see the drop down arrows on the right of the look up fields.
 I created a query and the result still shows the ...

Access 2000. I have a complex form with ten subforms, some of which also
contain subforms. After working properly for a long time, one subform loses
its link to its underlying table. I have not been able to trap it. The only
thing that helps is to close the form and reopen it. I ...

I'm trying to make a lookup combo box for a subform, but i find out that i
dun have that option when when i use the wizard to help me do the job.
it is possible to have a lookup combo box in a subform? and what should i do
if it's possible?~

           I want to write a form so that a control visibility depends on
the control value.  In other words,
           if control = emtpy string then control visibility = no.
           I tried to do this on format event but doesn't work. Can anyone

Under the data tab of the properties, what do I need to type in the "filter"
field in order to have an ID number automatically generated by my back-end
system?
Thank you.

I am trying to set up a checkbox page that would allow the user to select
from various options to be applied as a filter to the dbase.
Table - Contact
Form - Contact