I have an unbound form that contains two subforms.  One of these subforms is
a continuous form comprising rows of textboxes.  What I need is to allow the
user to navigate around the textboxes as if they are cells in an excel
spreadsheet using the arrow keys.  

I have a form with a subform on it.  When I click on the edit button on the
subform item row, a pop up is shown with data prepopulated from the datasheet
subform.  I make my edits and then click save to save my changes to the
subform, but it creates a new line item on my subform.  ...

I was wanting to change how a report opens based on a drop down box
called "groupcriteria" in a form.
Eg, I will have monthly, 1/4 and year as options.
The report is called "MonthlyDataALL"

I want a form to open when a row is selected on a list box and the
Enter key is pressed but not sure how to trap the Enter key.
Any help will be appreciated,
James

II have a main form with 2 subforms
MainForm
Subform1
Subform2

I am using the below code to auto fill two fields.  However I can never get
column 2 to fill.  I can switch the Phone and Email order and only column 1
will always populate but never colunm 2?  Any idea why?
Private Sub Contact_AfterUpdate()

I have a Query.  I'm trying to run a DSum() from it and I keep getting an
error.  What is the correct Syntax here?
SELECT tblCheckDetails.CDItemID, Sum(tblCheckDetails.CDQuantity) AS
SumOfCDQuantity, tblItems.ItemName, tblCheckDetails.CDPrice,

This is what I have for cmdAddRecord:
Me!Mysub!EstAdmin = Me.TxEstAdmin
Me!Mysub!EstBuilding = Me.TxEstBuilding
DoCmd.GoToRecord , , acNewRec

Hi I want to open up one report and be able to change the criteria I
open it with.
Dim stDocName As String
stDocName = "MonthlyDataALL"

Hi I'm new at VB.  I want to write code with a Select case Statement that
would validate data to be entered on a field lngAccountNum  that would have
an account number range i.e 1000 to 1999 if The txtAccountType field =
"Asset", "Liability" would be "2000 to 2999, "Equity" "3000 ...

A form contains a Calendar Control 11.0 in the formheader area.
The form is a continuous form.
When no records are present on the form the Calendar Control is
locked.

Dear Friends ,
I have 2 querries  viz qrybilllog & QryBudget
qrybilllog is summury of state wise billing recorded for a period  -with
fields billed_date, bill_Amount, Branch_Name

I often use the OnExit property of a control for example to look up the
description for a Product Code.  This causes problems when the Exit key is
pressed if one of the controls that is checked has the focus.
Does anyone know of a way round this problem please?

I made a crosstab query, which works real nice, but in the first query
that leads up to the final crosstab ( i have 3 queries before the
crosstab) I have the item # field criteria linked to a combo box on a
form, so the selection on the combo box is what is searched in the

I'm trying to compact and repair and I'm getting this error message...
"tableTEMPMSysAccessObjects already exist"
Anyone know what this means?
Thanks