I am using an on Double Click event to filter based on the current value on
that field. It works when I use it on a number field:
Me.Filter = "[forMthYr]=" & Me![cbMthYr]
Me.FilterOn = True

I have two forms, FormA and FormB, based on table A and B.
Both tables underlying the forms have different autonumbers as the
primary key.
Essentially, what I need to do is build a macro that :

When I try to design a new form in A2007 it is always maximized and the
Min/Max buttons do not show despite the appropriate property settings.  
Furthermore I cannot change the value of the Moveable property, it is locked
to No.  However forms designed under A2003 and brought ...

Hi
I am updating a table through form.In the form written a procedure for On
Click event of Label.It works fine for updation.In event proc i have put a
macro(Action : Transfer Text ) with InputBox for getting date portion of the

A relationship between the "Financial Year" Table (one side) and "Customers"
Table (many side) has been created.
The record source for the main form is "Financial Year" and that for the
subform is "Customers". From Wizard was used to create the form which gives a

I have a form that contains order details and I run through a loop that
applies a filter to the form (only view one order at a time), and then
removes the filter, applies a different filter (next order) and then removes
it etc.  

I am new to this and a friend told me to get involved with news groups to
share thoughts, and downloads.  How do I get started ?

I have a subform displayed in Datasheet view with the followign fields:
Product Number (cbo), Product Name (cbo), Quantity, Discount %, Unit Price,
SupplierID, and Product Number (Ref.)
I want the user to select an item using the pull-down menu, enter a quantity

I have about 12 people to work on the database and each has own userID
and password.  Their UserID and Password input and the form link to
the query that has the filter on "UserID and Password" for their
input.

I have looked through the posts to see if i could find some help on it but i
still cant get things to work...
I have a form called Billing Panel.
I have a subform called BillingPanelTravelSubform

I'm trying to design a work order form that would contain a field that
I can assign employees to the work order.  On any given work order I
could have from 1 employee to 30 employees....I don't want to enter
the same information for every employee....is there a way that I can

I need an Invoice Number text box in the format of "0000-yy" where the “0000”
increases +1 automatically.
Thanks

I have a form called “frmIncidentForm” that has a “Next Button”, “Previous
Button” and “Add Button”
The form will only allow editing of records within the opened form.
I would like to disable the “Previous Button” and “Next Button” when the form

I have a calendar in a form.  We do data entry for information that could
have occurred today, yesterday, or a couple of days ago, like over a weekend.
The form always goes back to todays date.  How do I get the calendar to stay
at the last date entered?

this seemed so easy when I first started, but everything I tried has not
worked.  
I have a database with a form: form1 and a subform: subform1
the subforms are connected to the form by the SchoolID