This is my first post and I hope it'll be the lucky one since I've been
hurting my head with the following situation for a while now.
I need to be able to populate a table from all of the items located in
the listbox.

I would like to get support on how to get the sum of a field from a sub form
to be displayed on the main form.
I have tried this syntax =sum([Expenditure]) but I am getting an error.
Please help.

We have an Undo Button on a data entry form for deleting a the entry if a
mistake is made so they can start over.  After the data is entered we have a
Next Record Button programmed to allow them to enter the next record.
If the Undo button is clicked after the Next Record Button ...

I have an input for named "Inputting".  It checks to make sure the number
entered is not in the tblDNUMBER when moving to the next record because
tblDNUMBER.Number propertry is unique.  I would like to confirm the input
number is unique after the field has lost focus (I already ...

the problem i am receiving is that i can't work the subtotal pf my
receipt out. Basically i have a receipt with various details on such as
product,quantity,unit price,extended price. My problem is that i can't
work out the subtotal. I have code already in the extendedprice box

I need to design a form that when a user selects items from combo box, or
check few checkboxes, the program add the related score to each selection and
option and show it in another field. At the end I need the scores to be
stored as a part of the data with the rest of taht ...

I using the following code on a form which should take the current record and
send
it to a snapshot file via e-mail.  What is happening is I get all the
records instead of

i am not as good with SQL as i should be.  my dilemma is simple i have a
form that i load to populate a table.  what i need is for the form upon
loading to renumber a treatment number field.  this would not be a
problem if all data was entered from the form since i number things

I have 2 forms, which displays the same datasource.
I want to synchronize 2 forms.
in formload of Form1, I use:
set form2.recordset = me.recordset

running Access 2000
I enter 20-30 records at a time each having an eight digit number,
these are often sequential, so I would like the default to be the last
number entered....  BUT so that I can still change the number

I am having trouble with my invoice form. Basically my invoice form
consists of a subform(which includes invoice details such as which
products are brought, quantity and price)Outside this invoice form
consists of customer details, employee creating invoice and subtotal

I have a form that uses a query with 3 linked tables; leftmost (main)
and 2 linked tables.\The tables are linked in the backend database
using a one-to-one relationship with these settings
Enforce referential integ.

Can a drop down be set up to have a no value choice when the table it
references has no such record:
   Select Name __________  ^
                     <No Selection>

yesterday you suggested
=DLookUp("COMMODITY","RATES","Rate_Check = " & Rate_Code)
or add the extra quotes if Rate_Code is a Text type field:
 =DLookUp("COMMODITY","RATES","Rate_Check = """ & Rate_Code & """")

I have a need to pass a form name from one form to another in which the
original forms name will be used by the second form to populate a field on
the original after a search is done. I have been successful in passing the
form name in the OpenArgs parameter for the called form, ...