I have 2 combo boxes on a form, cbostate and cbocounty.  I want the cbocounty
combo to list only counties in the state chosen in the first combo box.  Here
is what I have, but the cbocounty combo box doesn't update and display any
counties.

I would like to be able to have my users tab off a control in a subform to
another control in the main form.  I know I've seen code on here to check for
tab keypress, and on that event kick them back to the main form, but I can't
seem to dig it up again.  I've also seen some people ...

I am trying to run an UPDATE sql query in a module. I get the 3144
error but I'm not sure where the error is. Any help would be
appreciated.
Thanks

I'm trying to open one form (frmSummary) from another (frmContacts) and pass
data to the second form when it opens.  I thought I had the code right, but
it's not working.  Not sure if this would make a difference or not, but
ClientCaseInfoID on the first form is held in a combo ...

I have the following input mask on my form \1:999999
This will always give the user 1:  and allow them to enter up to 6 numbers
after the colon.  But, if the first number after the colon is 1 for example
1234, it truncates the number one and only displays 234.   So, I type: 1:1234

Hi, I'm still a relative beginner with Access, but I've not done too
bad :P
However, I'm finding one thing very confusing.
Here's the scenario: I am writing a multi table db, and I need to link

I am sure that someone has already asked (and got an answer) to my
question, but I was not able to find the exact answer by searching
through the previous topics. Big part of it is probably the fact that
I am fairly new to Access, and probably was not searching for the

i have a problem ; how to solve that first let give you the table structure
that i have
i
1) [Sno] number

thank you for yor comments.
I Think my problem is in Total query (max),but I can't solve it at the coding.
as I explained at the most of times I need the result of my search brings
DOCUMENT No    title       max transmittal        max DATE

I'm quite new to VBA and Access, but I want to get the result of a
select statement into a variable to be able to work with it.
The select statement will return only one value.
Can anyone help me on this?

The user clicks a command button, a form opens, the user enters data.
Both forms are from the same table.
Same main form - the user picks a specific value from a drop down, a form
opens, the user enters data.  But when the user goes to the next field on the

I have one form that is linked to one of 3 tables. All data is successfully
entered to that table when I press Add button on my form. Now I want one
field to be inserted to another table as well. Here is the line of code, but
it's incorrect.

I have converted my Access 2003 database to 2007, but when I try to
compile the code now, I get an error "Method or data member not found"
with the word "edit" highlighted in the following piece of code:
Private Sub cmdImportTracks_Click()

I have two tables: Measure and Score.  The measure table is the parent table
containing details for various performance tracking.  The Score table
contains the monthly scores for the respective measure.
I've uploaded some screenshots to help with my inquiry:

Hi there - I'm pulling my hair out here!
I have a main form with audit details, a subform that lists the
non-conformances relating to that particular audit and would like to use a
data entry form to enter new non-conformances into the subform.