I want to link a ID with name so that if i entered the ID name linked should
appear automatically.

As per advice on this forum I have based my forms on my tables now rather
than queries.  This fixed a problem but created another one.
I have one control from one table, three controls from another and the
remainder (about 15) from the third table.  How do I get this to work?

How can you set a date field so that the user types in :
dd/mm/yy
and the result is automatically changed to
dd/mm/19yy or dd/mm/20yy

I have a form for data entry to a table.  The control source for the Client
Number field is the result of a dlookup -
DLookUp("[ClientNumber]","[qryGetClientNumber]","[FullName]='" &
[Forms]![FrmComboBoxFullName]![cmbFullName] & "'").  The dlookup returns the

i would like to use conditional formatting on a form that based on a search
query in a table, i would like to underline or bold the words that i search
for in the query, i have tried to use conditional formatting but i only
underline if the searched words is the only words in the ...

I've searched high and low on this forum and others, but I can't seem to
find an answer to this dilemma.  
I am using Access 2003.  My database has several tables, but the 2 in
question are Companies and Contacts.  Companies has a one-to-many

I have a Query with:
Date (date audit was done)
Pass (# good audits)
Fail (# failed audits)

I have a form that's bound to a table. The PK of the table is an autonumber
field.
after using the form in my organization, i enter the table and see 'holes'
in the autonumber field. there are numeruos entries of lost continuity in the

Probably a dumb question, with a simple answer but here goes anyway :-
Having selected a record via one of two combo boxes, User deletes the record
for the chosen selection. If a 2nd record is required for deletion, when the
User accesses either combo box the record deleted is ...

I have two listboxes, one that lists courses and one that lists classes of
that course.  how do I get the second listbox to highlight or select the
first (or last) class?  The rest of my form won't update until you select
something on that list.

I need to have a form's routine run from another form...here is an example:
frmContacts is loaded.  The user double-clicks cboCompanyID to open
frmCompany
frmCompany displays other contacts for that same company in a listbox.  If

Thanks for any help.
I have a form that views at a query, and there are some negative numbers
that are shown as -xxxxx in the form. Can I display as 0 for all the negative
value?

I also am having problems opening a form to a specific record.  I have a
single table that because of the amount of data I enter on two different
forms.  On form 1 I have a command button to open form 2.  On form 1 I have a
name field that is extracted from table A.  Form 1 also has ...

I'm using Access 2003.
In a form I have a text box into which users input memo information. It
carries enough info that the control requires vertical scroll bars.  When I
put my mouse cursor into the textbox and scroll, though, the form flips to

I have a combo box in a form. I would like to have the record of the form to
update to what ever is chosen in the combo box. I am unsure how to do this. I
thought of using the after update on the combo box, and then using code for
the form to gotorecord of the combo box.....but I ...