I think I understand the "Cancel" part, but what does the
"as Integer" part do/refer to?

I have to check if the project no is not in the combo list and if it is not
than the system should pop a msg telling project no not found do you want to
add and than add the data in the list.
if it is a small combo box than one can see the values but if it is an

I recently split my database to a front-end and back-end.  On my front-end, I
have a button that I use to transfer a couple of text files to a table on the
front-end.  I now need to edit the code to transfer the text file to the
back-end.  How do I reference the backend table in ...

I've coded a label to become visible based on the number of results in a
filtered form.  The problem I run into is I can't set the label's visible
property to "no" if the query is null.
Private Sub Form_Current()

When my general-purpose form opens to a new record, the
following dialog arises:
Syntax error (missing operator) in query expression
'[IvSurvId] ='.

Using the Access 2007 Form Wizard to create a form from a table would
be a great convenience, except for one thing.  The label-control pairs
it generates appear to be inseparably welded together.  For example,
if I want to replace a text box control with a combo box, I can't just

I have a form that displays mail date and employer.  Mail date is a combo box
populated by a query.  What I want to be able to do is populate the employer
list box based on the selection from the mail date combo box.  I want the
List to re-populate everytime a different date is ...

I have a main form with a subform control. I have several subforms that I
switch in the subform control using a combobox. I pull up a record from the
main form (main table=tblClients) using a combobox. The problem is when I
switch the subform in the subform control, the record on ...

Basic concept:
private sub AppendData()
on error goto err_AppendData
dim stRptName as string

I have: A continuous form with a checkbox in each record.
I want: The background color of the record to change, depending on the value
of the checkbox (False = White, True = Red).
Any suggestions?

I have a form named [frmPKsContainerFills] with a subform named
[sfrmPKsContainerFills]. This subform has the subform
[sfrmPKsContainerFillsOFs] with a control named [ml]. This control's source
is:

I have some forms with both a databound combobox/listbox in one sub
form and a second subform to create new rows for the lookup table.  In
the AfterUpdate event of the 2nd form I requery the combobox/listbox
in the first.  The problem is that in some cases the combo/listbox

When I open a form, I would like Access to go to a specified record
that meets the criteria in a certain field using the
'DoCmd.FindRecord' command in VBA. Unfortunately I have not had much
success this way.  Can you explain how I can find a record based on

I have a form with two unbound combos on it. I also have a subform
associated with a particular query which retrieves date for a number
of Tests. I have linked the unbound combos with two of the field in
the subform. So, I can now filter my Tests by Tester and Day Tested.

I have a form on which are a set of unbound controls (mix of text and combo
boxes).
The controls are unbound because the form is set up for a batch update; i.e.
user can enter data and once the form is filled in, the user must click an