I have a main form "Customer" and a subform "Address". They are linked using
"CompanyName" field.
The record source of the main form is a table (Customers). The record source
of the subform is a query based on another table (Addresses).

Is it possible to retreive in a form the description of a field that we find
in a table?
Best regards

I am trying to format phone numbers in a text box in a form that will
display the following two different scenarios:
(333) 333-3333 ext 33          or              (333) 333-3333
Haven't come up with much luck.  One time i was able to do it, it

I am trying to open a form from another form if a check mark is check, and
have a field in the newly open form automatically populated with the primary
field value.  I have the new form opening when the check mark is checked, and
I am using an If statement to do so.  However, now I ...

I have a database that is used to keep track of our stock in locations which
we enter using a barcode scanner. 1 table lists valid product codes, the 2nd
lists the product codes booked in along with the location and quantity. There
are another 2 tables that log entries when items ...

I have a form with 2 subforms, one subform holds internal ID data and
one subform holds client ID data,
I was using the refresh form feature on a command button to refresh and
put the data into list boxes on the parent form.

Hi & Happy New Year!
I have a form containing a subform in which I want to automatically
copy information from the form to the subform.  Within the event
procedure for a button click, the code works ok for the first record

I am trying to make the default value the date of the first monday in
the month in an unbound box.  Is there a way to do this?
Thanks,
James

I have put a logical field in a base table with a check box on the relevant
form. Now if I check the box on the form them the check tick remains there
in place when I moved to an other forms. The logical check has only been
added to the relevant record, but appears on all forms ...

When I open my 2003 Dbase the main form is blank of data, when I select
"Remove Filter/Sort" then a err msg comes up " The value you entered is not
valid for this field", I cl OK and data appears in all fields.
How do I get rid of the preset ?? filter/Sort ?. I have searched all ...

Next Question. How do I stop the CustomerInfoID Field from displaying "
(AutoNumber) when I open a new or blank form?

How can I save the filter in the report disign view?  it is not saving it.
I press save and confirm the save but it dose not saving it.
what can I do?

An Access application is splitted into front-end and back-end and it was set
up to work as a client/server application for three users within the office
LAN. However a user need to access it from a remote location and he
suggested that I should set up the VPN and it will work ...

I'm trying to get a lot of fields from several tables onto one form. There
are also a couple of linking tables involved.
I'd appreciate any help or tricks. Sometimes the links work and sometimes
they don't and I'm not sure why.

Hppay New Year.
I have a form that is perfect except I have a list box to a related
table/value list.
In this form the list box shows the value list properly but when the user