Can you tell me how to refresh the values in a combobox only, using an event
procedure for the On Current event for the form itself? I do not want to
requery or refresh the whole form, just the combobox.

I have a combo box that is quite long in depth (large no of entries) and
makes for a confusing list of entries. It would be easier to read if the
lines were alternating colours.
Is it possible to create alternate line colors for drop down combo boxes?

I have a table with many fields, but I want to use the following fields to
pull data into a report: State, county, PT, ST, OT, VRE.  State & County are
a list of all states/counties.  PT, ST, OT and VRE are yes/no.  The are
filled in by a check box via form.  I'm trying to create ...

In query "filter-for-highest-archive-used" is a field called "volume number"
What I want to do is find the highest number in that field,
Then add 1 to it (as a calculation - not altering the underlying recoed) and
then display the sum on a form to inform the user what the next ...

I'm starting to seriously push my envelope of self-taught
understanding at this point, and I'm stumped at my next step.  I've
figured out how passing the variables to the sub procedure works
(whew!); and buoyed by that success, I think as long as I have all of

I have a form for entering recipies.  In the subform there is 2 unbound combo
boxes for picking the ingredient category and then the ingredient.
But if I move to the next record and pick a new category the first and all
the other records also change to the new selection.  What did ...

I have a combo box, a text box (a date field) and a check box in the Record
Source of a form.  Both combo box and text box are on the form and the check
box field is not on the form.  
What I like to do is I like to write a code to automatically populate

I inherited an old Access 97 database.  On one form there are 2 calendar
controls.  These have been working fine for years.  Now all of a sudden I'm
getting
"438 - This object doesn't support this property or method."   The snippet

I have a db that records clients and calls.  Most clients only have one call
-- but sometimes a client may have multiple calls.  
The tricky part is that for my Calls record, I need to record the date of
the call (CallDate), and for the Client record, I record the First Contact

I have a main form which stores client information to Table1. This main form
has a
subform which stores records for that client in Table2.
When I add a new record for a specific "Client" I want to pull previous

Im trying to have a company logo at the top of my report. The problem is that
I only want it when the reports "CompanyFrm" field is TSWS. My CompanyFrm
field is a dropdown box in the form that places the address of the company
from at the top of the report. Is there a way that when ...

I have an interesting problem (maybe its not so interesting to the gurus who
frequent this board :) ).  Here is the back ground information:
I have a form that contains tab controls and several sub forms. The main
form contains a control that dictates what data is displayed on one ...

I need help with lost focus event. I have a table(tbl_appr) with social,
appseq, audit type as primary key. One social can have many appseq numbers. I
want to have a lost focus event on social so that when a social is entered a
message box should appear with all appseq numbers ...

I have an external VB6 program that captures signatures from a touch pad by
drawing directly on the from or a VB picture box.  It uses the VB Pset and
Line methods of the form and/or picture box object to do the actual drawing.
Is there any way to do this in access using either ...

Ok, i have a mulitple selection listbox, i want to store the selected values
into one field with each value seperated by a comma in the field. Im not
interested about how it is not good practice and how it is not good to do. I
just want this feature on my form, i have no ...