I want to exact the second column of the selected items in the multicolumn
listbox and concatenate them into a string. Before the last item found, I
would like to insert the word "and".  This is my code, I am not sure what is
the best way to find the last item in the for loop.

I have a filter form that uses unbound text fields to search for records.  A
reset button allows the user to clear all the text fields.  Here is the code
associated with it:
Private Sub ClearFields()

I've a problem with a form's recordset.
On the onopen-event i set the form's recordset via ado, but when i use
the standard printbutton on the toolbar i get the message that i could
not find the recordsource. This correct because i use recordset.

Can someone please help to spot the syntax error in the following.  The query
works fine outside of VBA, but it will not make it past this step in my VBA
code.
strSQL = "SELECT Sum(tbl_IPLs.[IPL Credit]) AS [SumOfIPL Credit] " & _

I have posted this question in the wrong section...so here it is again.
I have a texbox on a form. This text box will stores numbers with a
maximum of 2 digit.
I have created this input mask "999.99;0;_"

posted it already in modulescoding but pressed some button in OE and now the
'modulescoding ' does not seem to be active anymore...
sorry guys ..... I cannot find a way to get it 'bold' again ....
here's my problem ...

How can I jump from textbox1 to textbox 3, skipping textbox 2 in the tab
order, because of the selection chosen in textbox1?

Have a form with a list box come up when a query has more than one record,
the list box shows the possible CNC machines that the process can be run on.  
I want the user to select the machine from the list and have that record
printed.  Do I write code for a double click on ...

I have a combo box that contains the following "after update" event procedure:
   strSQL = "SELECT tblSubRegions.SubRegionId,
tblSubRegions.SubRegionDescr, tblSubRegions.CopTpart,
tblSubRegions.SubConfCurr, tblSubRegions.SubRegEmail " _

I'm doing exactly what the For Dummies book says and it's still not working.  
I want a date/time box on my form to have the focus when the form is opened
so have written this....
Private Sub Form_Load()

Is it possible for my [List38] which contains ("TV", "Newspaper", "Radio",
"Other") to pop up an input box when the "Other" value is selected, so that
the user is required to say what the "other" actually is?  The text value is
to be stored in a field called "ReferralSource".

I have a list box that contains values from an event table. When a selection
is made the value "EventNameID" is inserted into a registration table along
with the "ContactID". Below are the fields in the event table.
EventNameID

I would like to load a combo box with words from a string.
For example Info = "The quick brown fox jumped over the lazy dog"
Combo Box =
The

I have a list box that is populated by a query. I then have a check box and
a text box. when the check box is checked i want the contents of the list
box to be put in the text box.
I have:

I'm new to Access Form and I've asked a similar question without meaningful
result, ENV: Access 2003.  Here I'll give it another shot.
The question is, I have a form, say, field A shows a list of companies, its
data is generated by a query like