Ok, I have a form that the user select a individual from depending on the
Individuals number I would like to change one subform to a different subform.
Is there a way to do this in code?  
Thanks for any help.

Our fiscal year starts in November.  If I have an unbound field in my form is
there a way to have the value of the field to defualt to the current month?
So If it's November I want the field to have the value of 1.
Nov =1, Dec =2, Jan=3,  Feb=4, March =5, April =6, May =7, June=8, ...

This is a very basic question.  Why can't I edit a textbox that's bound to a
table?  AllowEdit is set to Yes, and Enabled = Yes.  What am I missing here?

I have designed access forms to show my data (originally from an excel
spreadsheet) in the look and feel that I want.  I have two questoins:
1. Is there a way to get access to recognize line breaks? Right now, I just
get squares showing up everytime it should be a line break

I have a form and on this form I have a button to open up another form to
enter notes. Once I click okay I want it to save to that particular record on
the main form. However it doesn't, when I go back to look at the data,
nothing is there. I have this logic in my form:

I need to create a MS Access database to manage a collection of
roughly 5,000 memos. Each memo is essentially a text, anywhere from 50
to 1,000 words, and most memos contain mathematical formulas requiring
specific formatting. Currently, the memos are scanned pictures and I

I need a little help while working of MS Access 2000.
I have a table which contians two columns labellbed as A and B. In
column A I can either enter Vegetable or Fruit (combo box). Now what I
want is that if I select Vegetable in Column A list of Vegetables

I have a field that holds the "units" of a measurement as a string. It can
be something like "kg" for kilograms or "m^2" for meters-squared. The folks I
am working with keep asking if there is a way to display the latter with a
superscript, as in m2 (with the "2") being a smaller ...

I have built an Access database that has as its primary table tblAlumnus. The
form frmPersonal is used to add and edit the record. It provides a command
button to link to the form frmContact to maintain the contact information;
however, in frmContact, all the fields are protected ...

I basically am looking to modify a form so that particular fields are "greyed
out" and won't allow entry if a certain value is chosen in another field.  
For example, the first field will be type of contact.  If it is "incoming
call", I want certain fields to require a null value. ...

Hi
On my reports form I have a command button that when you click it, it loads
a reportform on the criteria in my combo boxed.  I have pasted the code
below.  My problem is that it loads the report but for all the records and

I have a form that I've been designing... and for some reason, all at once,
it beeps back when I try and update records or input data.  I'm unable to
make any changes in this form view?  Help me please?!

Is it possible to use the vertical scroll bar to scroll down a continuous
form and have the top record visible be the selected record?

I posted this on General questions.  Please accept my apologies - but this is
a Form question.  
How do I remove a filter from a form automatically?  I have a doc form that
lists pts assoc with doc.  Upon double clicking on specific pt.  I have this

I have a tabular form where one of the columns has a sum total underneath the
column at the bottom of the rows.  It is working correctly except when I
apply a filter.  When I apply a filter the sum continues to reflec the total
for all rows instead of just the filtered rows.  Is ...