I need help!  I want to make a form where I can select a class from a drop
down menu, then select the students from a combo box or something, and then
hit a button that will add all of those selected students to that class.  I
don't know what code to use for this button or ...

I have a combo box where i store some of our product numbers for my users.  
The box works great for all product numbers that do not start with a " 3".  
When my user begins typing a number that start with a "3" for example "35022"
the auto fill is filling in the first product ...

   I have form with listbox, subform and an unbounded txtbox.
   When a user clicks on a listbox, it'll fill out subform and txtbox
(txtbox control source using dlookup).  Txtbox pulls up info from the table
just fine, but users are unable to edit - "control can't be edited; ...

I have added a data field in a table and want to link it to a bound text box
on a subform; however, the field does not show up in the field list.  The
table is linked to an append query, so I'm not sure if that is causing the
problem.

i have this code on my textbox417 on a sub-form
I want to find the difference between the current date and the max date of
BillDate
how many days have passed since the invoice was sent.

How do I set the default value for a field on a form to be a value that is
stored in a table that is not in the query for the form?  Use a simple
DLookup function?  Something else?
Jerry

both textboxes are on the main form; Pay and Bal
Code is being run on the current event of main form
right now the label show up when Pay  is zero and Bal is zero
Pay should not be zero, but Bal is ok to be zero

Using Office 2003 -
I have a table with two fields "Date of Contact" and "Comments".  The
Comment field is set up as a memo field so that the text can be limitless.  
My co-workers will write in these fields any time they speak with a client.  

I know this is a silly questions, but I cannot seem to see to add 4 fields in
a form.  I tried using the =sum([amount], [amount2],[amount3],[amount4]), but
it does not seem to work.  Any suggestions?

How can i make my label visible if the user answers yes to the print?
The label is named   Label470
default is set to label470 visible is no
If vbYes = MsgBox("Do you want to print the customer's receipt?", vbQuestion

The =currentuser() worked on Friday I thought, but today, went to let people
test it, and it backfired on me... my form is now based on the following
query SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser())); but the query is not even pulling my

I want to use a form with an activeX Calendar on it [frmCalendar].  There are
many date fields throughout other forms that when dblclicked on would open
[frmCalendar] to allow the user to select a new date.  I have this statement
in [frmCalendar] after the new date has been ...

I have a fairly simple report which is providing odd results.  I have a
report with 2 levels of groups and a qualtity - contribution.  I would like
to total contribution in the footer of both groups.  I am using the formula
=sum([contribution]).  The fields in the data base are ...

When I enter in an Access Subform, I would like it to have a new record only.

I would like a new record to appear when entering in a subform.  The Main
form Data Entry Property is set to no, because I need to see all the items in
the table, but the subform I would like to have only a new record show.  When
I set the subform Data entry property to yes, it ...