In a form i have a table of which one field uses the following dlookup as
the control source.
=DLookUp("[CourseCost]","[tblCourseInformation]","[CourseID]=[CourseUndertaken]")
Althoiugh the correct data is appearing in the form, the data is not being

I had a form that calculates 2 fields (on reality it has actualy a positive
and negative values) i just change the format that will only show all the
positive value.  Now i need to sum it up (in different textbox)  for all the
positive and negative values.  

I have searched previous answers and do not find that fits my exact
situation.
I use a form linked to the table for input of data. There are multiple
users. This morning I did some work on the database:

I am trying to design a form where users can add up to 9 contacts with phone
number/fax/email fields etc. for each company. However most will only have
one or two contacts so I would like the telephone, fax and other fields to be
hidden unless something gets typed in the 'name' ...

Thanx for the help I received. Helped me a lot.
Now I have a second problem. On my one form I have 5 fields.
EmployerRiskFactor, LocalityRiskFactor, DriverRiskFactor, CarTypeRiskFactor
and CompositeRiskFactor. The first four get their values from choices that

Can someone help me on how I can view the last entry that was entered onto
the form. I have a field "VP reference" which is my primary key so when I add
in a new entry with a new VP reference it gets sorted automatically and
therefore it does not allow me to see the last record ...

I have a form (RFI Resolutions) that I want to open with "Allow Additions"
off, so when the user scrolls through, he cannot scroll to a "new record".
Works great when I open the form on its own. But when I open it from another
form, using a button and a macro to do so, the new ...

Mental block here!
I have a table for companies and a table for company contacts and I want to
create a form whereby when I select a company from a drop down it changes
the next drop down to only pre entered contacts from that company.

in Access 2003 I have a customer form with one control with several tabs.
Each of the tabs shows a seperate subform of a table which has a one-to-many
relationship on the customer form.
When switching between open forms using the Window option on the menu bar,

I have tables
Drivers (DriverID PK)
Warnings (WarningID PK)
DriversWarnings (DriverID and WarningID PK)

I currently have a calculated control using the data source:
DateAdd("w",1+[EstDays],[dtFileReceived])
My problem is that the calculated field continues to include the weekends in
it's calculations. Any ideas?

Is there a way to put today's date in a field when a button is clicked?  I
have a button that will send an email.  When user clicks the button, then I
would like the current date to populate in the datesent field.
Fields:

I am trying to write some code to be performed at the on Click event of
selecting a tab on my form. This event, however, only seems to work
spasmodically. Is this a 'feature' of Access 2003 and is there a way round
it? I notice an earlier question was posted and the advice was to ...

Firstly, I’m not a programmer, but just somebody who find’s this very
interesting.
I’m building a database for a company to control their insurance on their
vehicles. I have two forms, frmNewEntry and frmClaims.  All the vehicles are

I am trying to design a database from scratch that duplicates some of the
functionality in this database template from Microsoft:
[url]http://office.microsoft.com/en-us/templates/CT011366821033.aspx[/url]
In the form "Classes Subform" when you click on a Students Name the rest of