I posted this about a month ago and didn't get anywhere with it.  I
have been struggling with different possible solutions but still
cannot get this form to work as expected.
Initially the form opened based on a sub-query which worked just

I have a table that contains member address and I have a table using
recipient addess. These tables are linked via member number. I currently have
the database linked to a mail merge in word. I have set up an option button
in my form and asks which address I want my letter to be ...

I have a form with a combo box that looks up values from a table.  There are
three columns, ID, lngClient and txtCompany from tSuppliers.  The cbo is
bound on column 0.  ID and lngClient are hidden.  
When I create a new record and select a supplier, say Alpha Inc. it records

I have a form with several fields. Two of them named Categoria and Familia.
Every Familia has one or more categoria.
I would like to show only the categoria for the selected familia.
So, I have this code to perform the selection:

Using Office 2003 and Windows XP;
I have a form that is bound to a table. On the form I dragged several of the
fields directly from the field list and it opens in datasheet view.
I would really like to add a couple fields from another table to this form.

In the Help file for Access 2002, it states:
"When you open a form containing a subform, the subform and
its records are loaded before the main form. Thus, the
events for the subform and its controls (such as Open,

I'm using Access 2003 and Sql 2000. I'm trying to sync 2 combo boxes that are
in a sub form. The 2 combo boxes are Branch and Department. I'm using the
code below to sync the 2 combo boxes.
I'm having 2 problems. One, when I open the form the Branch combo box

I want to create a form where if it closed or a command
button is clicked it will cut the record and append it to a certain
query.So that every time the form is open, there always no record in it.
I also want to put an option group ( probably radio button ) on my form.

Can I do check duplicate using VBA when user enter data in a certain field?
If the data that tuser entered was already in the system, give a message
'Duplicate data' and the user have to enter a new data.
Thank you in advance.

I have this code for the afterupdate event on a text box that has data in it.
Me.Text732 = Replace(Abs(Val([Text732])), ".", "")
When I past this data 0000272400123456 into the text box, it gets rid of the
0000, becomes 272400123456

I have an application that does this in Access 2003, but I need to do
it with Access 2002 and Word 2002. Is there a way to do it?
Stapes

How can the value typed into a textbox in a record not yet
saved, be extracted?  In the Help, I've noticed "OldValue",
but nothing for Dirty, or New Value.

Not sure where the best place for this topic but here it goes..
How can I have a combobox populate itself with a list of all the linked
tables in the DB? Specifically tables that are linked to other MDBs. I have
ODBC connections to an Oracle box that I don't need to worry about.

Hello, All,
Well as you can see that my question is about changing the screen
resolution, and i know a lot of people are against the idea of
changing peoples Settings. and all the knock on effects it causing

I have a form with a credit card field. They would like the field to be
formatted as a password field, except the last four digits should be shown as
number. (ex ************2345. Please anyone Help
thanks