Has anybody had experience with a form's query criteria conflicting with its
filters?
On my form, a number of criteria for the underlying query are set via combo
boxes. These work just fine. I use the form's filter for criteria that was

I have a listbox that with the MultiSelect setting at 'Simple'.  I would like
to have a textbox populated based on the listbox options selected.
For example, listbox contains the following entries:  John    Jerry    Jim.  
I would like the textbox to read John, Jerry, Jim.

Logically I believe this should work and actually, sometimes it does
but there must be something "illegal" about what I'm doing because it
eventually crashes MS-Access (2003 SP1)
In a nutshell - I have a control on a line item of a sub-form that is a

I'm having problems with this. I trying to only show my custome menu bar and
only show my menu bar while taking off the default menu bar. I created a
custom Menu Bar called "Custom1" using the Toolbar tab of the Customize
dialog box. It only contains the File and Printing ...

My word document contains merged fields from Access.  If I override a merged
field value and then save.  The next time I open the word file, the Access
field values reappear?  How can I resolve this problem?

I would like to create an option group that allows multiple selections.  Is
there such a feature?
Thanks in advance for your help
Greg

In my main form, I have a field that references the Subform.  In the control
source of the field in the Main Form I have:
     =DMax("[RevNum]","REVS","[DrawingNumber] =
[DrawingDataSheet]![DrawingNumber] ")

I have a form called "frmPrimary" which contains fields "txtAddress" and
"cboStreet".
I have a subform (linked to frmPrimary) called "frmProject" which contains
the field "Keyword".

I would like to be able to change the appearance in some way of a Tab
control Page caption. I want to be able to do this when a field on the page
has some data in it.  Only the caption of the Pages which contain data are
to change. The rest are to remain standard.

I have a form with a subform on it and also a list box.
The subform determines what must appear in the listbox.
Whenever a row is updated, added or deleted in the subform, I need to
refresh the listbox. How do I do that and how do I refer to the listbox from

Here is the code on a command button on the parent form:
Dim strFilter As String
Dim strAgent As String
'Build criteria string for agent field

Good afternoon all,
   Is it possible to requery a subform and also apply a filter?
This is what I tried, but it is not applying the filter:
        Me.sfm_SalesDetails.Requery

Hello all..
 Is this possible...
 I would like to create a form that will run a query..  It is a datequery.  
I would like to have two calenders displayed, the person can pick the in

Does anyone know of a way to display the list of items from a combo box
simply by passing the cursor over the field (as opposed to clicking on the
down arrow within the field...the way it is usually done)?
Thanks.

I use Column(x) to retrieve an item from a combo box selection, via an after
update event.
Example:  me.mycontrol = cbo.column(3)
The column is formatted correctly for dates, etc., but my "mycontrol" does