I have a form with a subform. The subform has a combo box that lists people
that might share in paying for a product (The list of people is in a table).
The user, when in record #1 of the subform, selects a payer from the combo
box and in the next field, types in how much that ...

I am using =Choose() command to display only current users of my database.  
This allows me to limit the drop-down list of current users only while
keeping the records of past users intact.  This has worked well, until now.
Apparently, there is a limit to the number of values for ...

For some unexplained reason, the forms in one of my databases has a different
appearance than my other databases.  In the different one, for example, the
command buttons rise and fall a bit when the cursor passes over them.  They
also change colors as well.

I embedded a chart in a form (with chart wizard) - it looks ok in form view,
but when I do a print preview, the form looks good except the chart: it is
blank! There is a blank and empty square on my printed page instead of the
chart..

Can a form be made to add data by just keying a number ID and then the rest
of the information will appear plus a blank cell for the new data.  My table
has product information and each one has a separate ID number.  I want a
input form where when you key in the product ID you ...

I have a delivery service which is composed of various routes.  The
route stops have been defined in database tables.  Route sheets are
printed based upon these tables.  However, I need to have the stops
print in an particular order/sequence; i.e. first stop, second stop,

I inherited a database and in order to keep from rebuilding it I want to
change the way a value is populated in a form field.
Basically, the form has an order ID (autonumber) and an order number (text
with number)  I want to change the order number to a pure number and then

I have a form with a sub-form.
I only want the user to be able to enter one record (never more).  How can I
limit it.  Right now I'm having issues because the users accidentally tab
through the form onto another record and make duplicate/triplicate/...

I open another form from a master form.  I pass values with setting the slave
form like fields equal to the master.  The question I have is how do I retain
the value without having to open the master form.

Can anyone tell me what might be going on with this simple code.  I have this
code on a command button, it does what I want it to do.  When I close the
form, it say it can't save this record.  I close the form and the record is
in the table.  I'm sure there is a better way to do ...

I am trying to change Back Color of some rectangles, but I don't know what
"code" is for which color (except black=0 and red=225) in Visual Basic. Can
anyone please help?
I'm actually after dark grey and light grey, but it'd be nice to know a list

is there a way to populate a text box with more then one search criteria. For
example, could you enter a search for all 50 states, or a group of customers.
I tried uploading multiple rows of data using a csv file, but that didn't
work.

Was writing a little routine for someone who needed, with a datasheet or
continuous form, to have FieldTwo's back color change when FieldOne has focus.
I added a boolean field, FFlag, and set it with the following code:
Private Sub FieldOne_GotFocus()

I am learning to understand the code below.   I know it's complex for
me to figure it out.   Is there a way to add the code if the field
name label become value.   I got the excel file that exports from the
web survey.   It is very difiicult for me to convert.   Your help

Hi everyone. I have a problem that I've been struggling on for a while and
quiet frankly need help!
Ive have a main form based on a query and a subform based on an existing
table. all the information required is their at it all works even when I