I have a subform with fields on it that are present when i first open the
form.  But when I click on a status button, I'd like the subform to change
the fields that are present.
For instance when i first open the fields are formid, lastname, firstname,

I have several listboxes that are mult-selectable.  In my code below, when I
select a row, I notice that the row I select in my listbox isn't being stated
in my code.  So if I select index(1), it's not stating that I selected row 2?
I have all the listbox attributes the same, ...

I have a form that calls up a report. The form has a checkbox and if checked,
changes the recordsource to QueryA. If unchecked, it changes the recordsource
to QueryB.
When I try to run the report, I get a run-time error of 2465 and the message

Access 2003:
I am trying create a record of user login with a simple INSERT INTO to a
separate table which logs user name and date & time. This is executed when
they click "OK" on an existing login form. The form coding is already working

How do I pull records from Notepad...for example, pull records from notepad
where field criteria matches a selection from a form list so I can see a shot
of a total amount before selecting another criteria from the listbox.

I have a subform with code on the AfterUpdate event on one of the subform
controls that prompts a requery on a pull-down on the Parent form:
  Me.Parent.cboList.Requery
The subform and the parent cboList use the same underlying table, but have

I have created a form with a combo box (PartNumberCombo) that, using a table
as its row source, the user can select an available Part Number and by
clicking on a button this Part Number is added to a List Box (ListBox).  (I
am simplifying this so hopefully I have included enough ...

Good Day!!
I have a very wierd problem here.
i have a form that is bound to a table with some bound textboxes, and some
non-bound text boxes, etc... nothing out of the ordinary.  but when i open

If Year(Me.[oTDLdaTE]) <> Year(Date) Then
MsgBox "Year is incorrect, must be current year", , "Cannot continue "
Cancel = True
End If

Access 2003
Vista Business
Form Name - C25Transactions
Subform1 Name - C25TransactionsSF

Below is the SQL of a query where the field "Period1" needs to be the
contents of a text box on a form. How do I do this?
INSERT INTO tblTemp ( Period, Product, SubProduct1, SubProduct2,
[MR/NMR/OM], Channel, OutputDescription, [New/Existing], COMMONELEMENT,

When I set the tab order in the properties of the tab sheet, they renumber on
their own and the tab order is all wrong.  Is there a way I can set the tab
order for each data entry field in VBA.  I have 15 tab sheets and about 12
tab stops on each sheet.

I have a form with 4 comboboxes (ProjectID, DisciplineName, SectionNumber and
LastName) where the user can select from any or multiple boxes, hit select
and the results display in a subform (this works fine). Once the results are
displayed the user can double click on any one of ...

Hi - I'm having a bad day today - second post on a totally different topic -
maybe I'm not thinking clearly but I am stumped.
I have a main form Frm_Employee with a subform Frm_PayData
(continuous)Pay_Data actually comes from Qry_Pay_Data.  The user is to enter

Is it possible to create code that I can assign to command button on my
various forms that closes the form the button is on and then opens my
"mainform"? I am trying to avoid having to write a macro for every single
form in my application.