I was wondering if someone could help me out with an Access Db problem.
The issue seems to be with the form which has two combo boxes for selection
from a list and are feeding these to a subform to display the resulting data
based on these selections above.

I have a check box on a form.....called Invoice. And on this form, there is
a textbox.  Here is what I am needing.......When the invoice has been
completed and billed out......i want the user to check the check box and
the current system date be entered into the textbox. Any ...

I am trying to use a combo box as navigation for a form in single form view,
allowing me (hopefully) to select the record for the form to display from a
pull-down list. I am trying to use the following code to achieve this:
Private Sub Combo40_AfterUpdate()

I have a subform (in datasheet view) that contains a list of values that are
totalled (individually) in some Summary queries. The Total values from the
individual summary queries are part of my main form in text boxes
I am unable to make a change in the subform update the totals ...

I am trying to use a listview control on an Access 2000 form and populate if
from a recordset using VBA. The problem is that the listitem is not available
for the listview control. I added the listview control using the references
under tools in VB. I've tried changing the view ...

Hi. I posted about this a few days ago in the Forms
section and received a reply that I queried. Since then
the Forms section has not been available. I thought Id
take another shot here, which is where I should have

I have a popup form which has a button on it to open another form which
maximises on opening.
When the button is pressed I want to hide or minimise the popup form. When
the maximised form is closed I want to then restore the popup form.

I am using the information from the following site to speed up performace on
my FE DB.
http://www.granite.ab.ca/access/performanceforms.htm
I notice a vast improvement, but I can't set the Me.form.recordsource = ""

Group:
I have a form that allows the user to search the database for a matching
record. The form has an unbound field named DescriptionSearch where the user
types in a search word. And there are two buttons at the bottom of the form

In tbl1 I have two fields (fldID and fldQty).  With the OnClick event
cmdButton on frm1 I would like to loop through all the records in tbl1 and
update fldQty based on the result of the following function.
Select Case ID

I have a subreport data grid.
When a user changes a value a particular field in the data grid,
I want to update another field for that particular record.
example: user puts a value into 5th row, 1st column of a data grid.

I posted this question a while ago and got some answers, but it didn't quiet
work.  So, here is what I have now.
I have Schedule Table which shows all the classes offered in the clinic.  
There is also a Rehab Schedule Table, which has the class name, start date

Is there a way to minimize a form using VB?
I have the Min/Max turned off on my form and have a custom button that
closes the form. I would like to make a custom button to also minimize the
same form.

I recently purchased Garry Robinson's "Microsoft Access Database Protection
and Security" book.
In his demo database -- chapter 5 -- Garry lists the form "frmAutoShutDown".
I tried to implement the Auto Shutdown form into one of my databases, but

This statement always returns false
I am probably doing this wrong
Dim MyHour
MyHour = Me.hour1 Like "[.5 - 24.0]"