Good Day Groupies!
I have 2 combos, Category Name and Sub Category Name
Category gets it's data from the Category table, no problem. It has an
AfterUpdate requery for SubCategory.

I don't know if I'm in the right place for this question.
I have a table (tblAggregates) that has the following fields:  RatesFor,
Aggregate, Price, Status.
I have a form based on this table and a combo box based on the Aggregate

I have a drop down field where a choice is made - below "Request = 37".  Then
the next field is an option box with 4 choices.  This is the code for one
choice [call it 'A'].  If they click here with the above previous choice,
then they have a decision.  If they choose to keep the ...

I have an update query that should only have 1 record to update or no records
to update when kicked off by a command button in my form. How can I find the
count of records to be updated to create my own message box, if the count is
zero instead of using the warning message box ...

This is a general question by a relative newbie to VBA.  I have a form that
contains (among other things) optional areas for entering vote and comment
information.  I have created a checkbox for each that, when selected, enables
the boxes for entering the information  I have ...

I have a tab control being used on a sub form that has 10 tabs. Within each
tab there is aproximately 10 questions that the user will need to fill out
for entry of a record. what I need to do is when the user clicks off their
responces the code underneath needs to send the ...

I have the following code that duplicates the main form, but not the subform.
   With Me.RecordsetClone
           .AddNew
               !ProjectName = Me.ProjectName

Hi Allen Browne,
I try to use your code to duplicate the record in form and subform but I got
a error message "Error#3265". BTW, my primary key value is not autonumber,
how to change the code to fit my database?

I have a tab control which allows the user to edit, add and delete records
within the tabs. Right now when a user adds or edits entries, the forms don't
reload right away unless a user restarts the from (moves from form view to
design view)        Is there a way of reloading the ...

I have a form and a sub form.  The main form is used to add an event
to a table and the subform has a combo box that allows the user to
select and event from the table.
When I enter a new event into the form, it doesn't show in the subform

I have a subform with custom navigation controls including a current / total
record text boxes.  When the main form loads, the total record on the subform
is 1.  If I manually navigate to the last record on the subform, then go back
to the first record, the total record shows ...

I have a database to track workorders and a form with a drop down menu to
sort by employee name in a subform.
The workorder ID is set so that a user can double click the workorder number
and it opens up the workorder form.  The problem is, I don't know how to get

I have a three table setup for storing a list of events each person
has attended.
1 - Person
2 - Events

In advance, sorry this is so long.  I cannot think of a way to compress it.
I have a vendor database.  There is a main Vendors table, and a related
PhoneNumber table (since there could be several phone numbers).
There are two forms.  One lists all vendors; the other is a subset of

I have a listbox which contains 1 column for which the values a
populated from a query. The query returns only 1 row hence my listbox
is basically a 1x1 matrix.
I would now like to use the value of this cell to change the