Hi people,
Can I use a multiselect (simple) to filter another multiselect (simple)? I
ask this because I don't see a filter property on the data tab of the listbox
properties.

I am building a database that will be used, amongst other things, to record
personal details after a medical review has taken place. One of the forms
involved has about 80 - 100 fields to be completed. Due to the nature of the
illness being monitored many of the answers will be ...

My application is very slow to display the main menu.
The main menu is a form with just a tabbed control. There are 5 tabs. Each
tab contains just command buttons, nothing else. There are 22 command buttons
in all.

Hi! Have have an order entry system in which I have a customer form, an order
form and a payments form. Sometimes the customer sends a check and so there
is no payment untill the check arrives. therefore there is no payment record
for that invoice. When the invoice is printed out ...

Scenario,
I have two listboxes, I can successfully move items back and forth between
them. (though I still cannot move multiselected items between both Listboxes,
that I can solve another time.)

I have a bound form, with a linked subform between sets of the main form's
controls.  (That is several of the bound controls appear above the subform
and several below.)  When I want the focus to go to the sub form, the
form_before_update event for the main form gets triggered.  

I have a one to many set up with corresponding form and subform.  Focus
begins on a combo box where account number is entered to either add a new
record and corresponding audits or pull up existing record to add another
audit.  The account number field in the table is set to ...

I have a simple flat file table that tracks my Time and Attendance at work.
Most of the fields are filled in as defaults, the only field I actually type
in is [Pay_Period] which is a text box. It used to be a look up, however, I
converted it back to a text box. It is a text field ...

How do I amend this code to check whether my field txtmonthlabel IsNot Null
and then only runs the rest of the code?
This code is on the OnClick event of a command button on a prompt form where
the user inputs a date range.

Dim x As Integer
x = InStr(Me.OpenArgs, Me.[Entity Name])
If Me.NewRecord Then
   Me.[Entity Name] = Left(Me.OpenArgs, x)

I would like to know if it is possible to connect a control that has a tab
control as parent to the form that is the parent of the tab control.
How do I this ?
Thanks,

I am currently trying to add this code to the after update of my combo box -
What I want the code to do is allow the user to use a name that is not listed
in the Reroute Contacts table - and then they can have the option to add the
name to the original table.  I don't know if I ...

Is there any way by which I can pass a public variable value to
a query?
I have a form with Public variable as -
Public myqueryvar as String

Hi all,
I need to populate my fields after I enter a date range and click my "Apply
Filter" button. Here's what I have
DoCmd.ApplyFilter "fltBilling"

I have a subform that has a DMax function in the BeforeUpdate Event.  The
code is:
Private Sub Form_BeforeUpdate(Cancel As Integer)
   Me!PunchID = Nz(DMax("PunchID", "tblPunchItems", "[JobNumber]='" &