My new question is:
I am trying to open a new form from my main form, for the same record I am
editing.
My code is:

Within an application to keep track of clinical information about patients
there is a registration form that, as well as recording demographic
information about an individual, also records their general practitioner (GP)
and the office address.

I Was Woundering if some one could Help Me, With this rather Simple
Problem I Have.
I Have 2 Tables
"tbl_Suppliers" and "tbl_Enquirys"

I have several data entry forms in a database. When I enter data in one
particular form, I want a certain checkbox on that form to be automatically
checked.
Can do?

I am trying to use the MSFlexGrid control, which is going OK except for when
I try to use a textbox over the grid for data entry.
The data entry etc... is fine. My problem is no matter what I try, I can't
get the text box on top of the grid - it is always behind and out of view.

I would like to write code that detects the row and column selected by a user
on a continuous subform. I have a subform that displays in continuous form so
that it looks like a list box. If the user clicks on in item within the
subform, how can I tell which column in which record ...

I am trying to get a record using a combo Box, but i keep getting Error 13.
Here is the code:
Private Sub Text105_AfterUpdate()
' Find the record that matches Text105.

I'm using Access 97
When I try to create a combo box with a particular query as a data source I
get the message
'Data cannot be retrieved from the source you have selected. You must select

I have a billing field that has a user enter an alpha number invoice
identifier and i would like to ensure that any entry in this field will be
large caps regardless if the end user keys in small caps. How is this done?

I've been posting the below all this week and no one's been able to help me
get things working. Please help, I need to get this working by Monday am in
order to deploy my app over via citrix .
I have a command button on a form "Print Case Report" that won't print

I am using Access 2002.  I have a form that I created for the users to enter
two parameters that will open another form.
Here are my steps:  
1) I created the Parameter form with both parameters(filters).

Hi.  I'm creating a report based on a company combo box selection and
a date range (2 text box fields).  I can't seem to get the report to
do both.  I want it so that the combo box selection (company) must be
choosen but the date range is optional.  If it's not filled in then it

Please tell me if anyone of you has an idea of how object's HEIGHT property
is different from the TOP in terms of scaling or units of measure? What I am
trying to accomplish is like getting 2 subforms resized to fit screen but at
the same time keep lower object's height unchanged:

I have a command button to run a report.  Clicking the button opens a dialog
box with parameter choices.  Clicking OK on the dialog box then previews the
report.  all this works OK.
My problem is tidying up the screen.  The dialog box stays on top, so I need

I have a form designed for data entry. It has to be a continuous form for
many reasons.
My user wants to be able to fill up the data of all the first field, then
the second, etc...