I have the following problem.
I have a listbox "called: lst1" which should get updated when I change the
value of another listbox "called: lst2" . This works fine. However I like to
see in as default when I open the form where the listboxes are shown for lst1

I would like know how I can, using code change the background colour of a
form, when a control on that from has a value set...
e.g., I have a main from with an option control on it, when this control is
set to inactive, I would like the main form background colour to be set.

Arrghh!
I simply have not discovered a reliable technique for finding answers
to "why do this instead of that?" questions in the MS helps, so I turn
to you good hearted folk!

I want to create a relationship for a supervisor over an employee.
I have a table (Person) with PersonID as the PK and CompanyID_FK as the FK
to CompanyID in the table Company.
In the Relationships window I created a copy of the table Person to get

I would like to get the recordID of the Record being deleted on a subform
with the BeforeDelConfirm event. When I select the record and click Delete,
the value of Me.RecordID is 0, rather than the value of the RecordID that is
selected. How can I get the value of RecordID for the ...

I am using Access 2003. Would like to assign every team member a score,
depending on their performances.
To this aim, I am building a form with team members general info, and then
in a subform I'd like to have for each question 3 choices (3 check boxes);

I would like to show the same datafield in multiple columns on one form.
Same as on a Report where you can indicate more than one column in the Page
Setup area.
Is it possible?

Here is the situation.
In a Call Center environment, using Cisco as the workforce management tool
and to enable agents to receive calls, is it possible to create a
user-defined form that will enable users to place clients on hold (or go into

I have a form with a subform on it that is used for data entry. What I'm
trying to accomplish is that when the main form is open, the user cannot
close it out until he/she fills something into the subform.
I thought of using a RecordSet.RecordCount method but is this the best way ...

Can anyone point me in the direction (Or mail me) an example of an rtf
control being used with an access database?
TIA

Hi. I've got a table with a bunch of fields including Boy/Girl, He/She, and
Him/Her. The Boy/Girl field is included in my form (but the He/She and
Him/Her are not on the form).
I want to set it up so that if I enter "Boy" in the Boy/Girl field on the

I am not sure if this is even possible but I will ask.  I have a form that
has 2 combo boxes in it.  The first selects a department from a Value List.
The second combo box will offer a selection of processes from a list that is
filtered by the first combo box.  I am using this to ...

Greetings All,
I was wondering if anyone has run across the problem I'm having with
concatenating rtf control contents and line returns.
I am using Steven Leban's rich text tool in Access 2007 (as

hello everybody, I would like to know if it is possible to make the status
bar of a form show some random (scrolling) text. I use this on all my excel
sheets and I would love to be able to do the same with access.
Thanks

I am going crazy. Tried some of the samples found here however does not work.
I have a form that is linked to a query.  The form is used to enter
appointments.  The users enter the account number of the client at the
beginning of the appointment form and the form auto populated some ...