I have 3 ListBoxes on a form. When I click on a
row in one ListBox I want to unselect any row
that might be selected in the other ListBoxes.
Thanks,

MS Access 2K, Windows XP
====================
Hi,
I have a main form with a subform on it. This subform is bound and is in

I have successfully change both master and relevant detail transactions to
new primary key fields.
Now I have the problem of changing existing detail transactions from an
incorrect key to a primary key which already exists on the master .. eg

I'm having problems getting a subform to refresh. The main form's text boxes
are filled based on a selection made from a combo box. I then have and
append query in the After Update for the combo box that should fill the
subform underlying table. The table for the subfrom is an ...

==You all helped me tremendously last week... please do it again!===
I have as many as nine groups of items from which to select one of up to
nine items.  The groups are coded by tens  (e.g., 10, 20, 30, etc.)  and the
items are in the decade of their group  (e.g., Item 11 belongs ...

I have a textbox on a form that I want to allow users to append to but not
replace.
The textbox is loaded with a text string - say "My favorite Fruit is"
I want the user to be able to complete the sentence.

I want to append text to a "Comments" memo field. The table only has two
fields: Order# and Comments (this table will be related to a linked table
from another database because I don't have authority to modify the other
table).  

I recently converted a form which was bound to a table to being bound to a
parameter query.  So far everything is working fine except the following:
When I move to a 'new' record the first field for data entry is a bound
ComboBox which doesn't retain the value AfterUpdate.  In fact  ...

I am very new to VBA for Access, so I will need to be hand fed on th
answers to 2 questions. They are as follows:
1. I need to run an external application (VBScript) from my For
macro

Hello there,
I'm working on the finishing touches on a productivity database!!!  The one
"bug" I don't like is users getting stuck when they input an invalid employee
id # on the main form.  I want the text box to only allow valid values found

I need to develop a form that will allow the User to edit table records.  It
would be ideal if they could browse/edit the data in the tables, and be able
to design the forms.
The basis of this is that they want a working "rough draft" and later be able

I use a form to update invoice information in a database.  The invoices
consist of multiple lines -- each time through the form adds one line in the
database.  The invoice number and date are the same for each line, and I'd
like to save users from having to enter this information ...

I have data entry form developed in Access. This data entry form is bound to
a database table. This data entry form has some textfields and a submit
button.
What I want to do is that when I press submit button. The record from the

I have a Payments Form that has a subform for entering charges. This subform
uses a temp table to store what is entered in it. I select a charge from a
combo box on the subform and enter an amount. Now nothing is saved until I
hit a button to post the payment and at that time my DB ...

In Access 2000, I have a form whose data I use to create an ADO recordset.  
When the cursor's on a record in the form, I'd like to capture the record
number.  Is there a property of the form or the recordset that I can use to
do that?  Thanks!