Crossposted on  microsoft.public.access.forms, microsoft.public.access.formscoding
I have 3 cascaded ComboBoxes on a continuous form and for some reason the three comboboxes show values only for the current row. other rows are blank.
The comboboxes have the required code and I ...

Background:
I have a Grant database with a form (frmGrantData) that has a control
source based on a table "tblGrantData" with the primary key
"GrantNumber"

i have a control whose source is based on a dlookup.  depending on the value
returned i wolud like to display a msg in the remarks field on the form.
the msg doesn't have to actually be entered as a value in the remarks field
and saved in the table.  it only has to display to the ...

The field 'TRADERSIGNOFFID' in 'tblApp_TraderSignOff' table is a
'Autonumber' and 'Long Integer' data type.
Somehow, I can't seem to correct SQL syntax error for this VBA update
query in MS Access.

I have a database to record our clients, their jobs, the project numbers,
etc.  In a data entry form I entered a drop-down list from which users can
select a project manager's name.  All of the project managers are listed in
their own table--with their employee number--and this ...

I have a main form with tab controls that has various option groups for
previewing / printing reports.   On one of the pages (tabs) I have a button
that runs a macro which opens and sizes another form which I'll call Form1.
On Form1 is another option group in a subform.  When I try ...

When I run my query it stuck is it possible that i can debug it
SELECT TOP 1 tblCredits.OPR, Min(tbl_CRCDollars.SumOfAMOUNT) AS
MinOfSumOfAMOUNT, Avg(tblCredits.Credit) AS AvgOfCredit,
Count(tblCredits.OPR) AS CountOfOPR1,

I copy a form from another database into my database. I need help how
to i link the table which is in another database with that form.
Thank you.

I have a number of worksheets that have their own id's and these are
connected to a project summary table.  Which will not accept nulls due
to the Ref Int.  As the summary table is more likely to have nulls than
anything else, can I change settings to allow null values.  Or do I

Is there a way I can keep a running total in a continuous subform?
Like...
1st Record(Main Form)
(subform)=

I tried this before but was not successful.  Hopefully I can explain
the problem a little more.  I have a costs form tied directly to a
costs table with several line items with unique record identifiers
(recordid) per individual cost code.  The costs table has several

I was wondering if it is possible to create a pivot chart from multiple
queries?  I have three queries that are each associated with a different
part.  The queries return the amount of each material used to create the
product.  I would like to take these three queries and create ...

When I create a subform in datasheet view, the form automatically shows the
lines with the sub records first and the line to insert a new sub-record (*)
is automatically at the bottom.
Is there a way to put the new sub-record line on top than the sub records

Is there a way "group form objects" so I can keep together, move, etc.
In Lotus I would just draw a select-box around the objects and the context
menu will have a Group (or Ungroup) option.

I have employee expense database.  Due large amounts foreign travel, want to
add foreign currency capacity into the expense input form - and record into
the underlaying table both the original amount and currency and the amount in
base currency.