I'm trying to set a form up to select a range of columns in which I'd like to
search for a specific string using presaved queries.
I'm thinking of having 10 text boxes, each displaying a single line of the
received data. I was then going to have to columns of radio buttons to

I have a form with basic contact information.  I want to add a 4 page tab
control with one or more of the pages with subforms.  In design mode I can
insert a subform on a page of the tab control.  However, in Form view, it
does not appear, only a fuzzy outline shadow of it.

Please I am using the multi-tab object in my forms.  All the text objects
from the first tab are appearing or repeating in the other tabs.  How can I
resolve this?
thank you

I've a form used as a main menu for my data base inserted with an ActiveX
Control Calendar thereon.  
I've an event procedure with On Load: (I learned this from this Discussion
Web.)

I have a form set up to display store locations (shopping center, address,
city, state, zip) and phone numbers.  My users want to be able to highlight
the displayed data as one item so they can copy and paste it into emails.  
Currently, I just have the info set up simply, with ...

Hi, I want to count records on a specific Field.  For example, on a Employee
form, I want to know from the Gender Field how many males and how many
females are in that specific Form. I want to use that number later on for
another calculation.

I have tied that two fields should equal each other After the update Event of
the first given field.  It works fine if I am actually hand typing the info
and hit tab - then they both are equal.  However when I Fill that field based
on a value selected in a drop down of a field ...

I have a form and subform in which I am enabling and disabling 3 controls in
the subform, based on "Null" criteria in a control on the form.  I am using
the following code and it works, except when I close the form and/or
database.  When the form or db is closed, the 3 controls ...

I would like to have a given field called job# be an autonumber - which i
know I set in the table field properties.  But Each time on the form that we
use to input this - you select the clientid first(from a dropdown) then input
the job# - I would like the job# to be ...

Hi, Got another question. I have several controls on a form that i want to
hide based on a checkbox.
Do i have to specify each control and its label, one at a time, visible or
not visible?

Sorry for posting this twice - I put it in the wrong area the 1st time.
My form is used to enter new contacts; but you can also use an unbound
control box to search for an existing contact.  Currently, when I open the
form it opens up to the first record entered (I want a blank ...

When creating a report, there are a few 'sneaky' ways to have a "running"
label next to each record listed (ex: 1 xxxxx, 2 xxxxx, 3 xxxxx, etc).  On a
form...not so much.
I thought of a running total (the first 'sneaky' way) - but that is not an

I have a form that has a drop box which pulls from a table of contact info.
In that table there are multiple names with the same company name.  How can I
make that drop down box only show the company name one time?

I have a form for entering Customer data.  When entering a new record,
I have a lookup combo box to validate the state that the user enters.
The combo box displays the state code and the state name. (ie. Ca and
California).  The state code is the bound value and the state name is

I have an Access application installed on four client machines running under
XP.  A few of the controls have ControlTip Text designated for the control.  
The text appears as it should for two of the machines but does not appear at
all for the other two machines.  The only ...