I have a form where on the Header I have an important field (name) but most
of the rest of the data is in the Detail section. When I chose "new record"
I have two problems:
The cursor is not active on the first tab enabled control on the Header it

I'm trying to build a system that has a table of possible jobs and a table
of students
Each student can choose 6 jobs in order of preference
I allocate a student to a job based upon their prefence  (and a few other

I have several reports that are printed from the form by using the following
code
Example
Private Sub Command209_Click()

1. My main form opens with a DoCmd.Maximized in OnOpen.
2. I want to pop up another form with some records when a button is
pushed.
3. Is there a way to hold the popup form to a non-maximized size rather

Me!myListBox.RowSource = mySQL
Me!myListBox.Setfocus
why would this code produce this error:
"you must save the field before ..... the Setfocus method"

Hi!
im trying to use dlookup as a control source on a form. basically, customer
chooses boat, boat looked up in table and hire charge shown in box with the
expression in it. the expression i have is:

After setting the rowsource in VBA for a combo box, I need to select the 1st
item for display in the text box part of the combo box.
Neither "Selected(0)" or "listindex = 0" work for this purpose.  Must be a
simple answer, but I can't find a similar question on this board.

Access 2003. Working with Canadian Postal Codes. Have Postal Code definitions
table. When a new individual is added to the members list by way of a form,
the address components are gathered (Building Number, Street Name, Street
Type, Quadrant, City) The objective is to use the ...

can you perform calculations in an Access form?

I need to add smart tags to my database but am working from Access 2000 which
dosen't have the smart tag function.  Is there another way of programming
something similar?

I'm a non-programmer, but savvy enough Access user.  I have mail merge
documents (Word) that I want to be able to open from an Access form with a
click of a button.  What is the code needed to do that?

It's me and my basketball project again...
I have  a form which lists the fixtures for the current round, and I am
trying to update two fields depending on the results.
Imagine we have Team A and Team B playing a fixture.   Both teams turn up at

Can this be done:
We have a form which has a subform. The subform can only be seen as a
datasheet. The recordsource for that subform has 3 fields visible PartNo,
PartName, PartType.

Ok so I have a subform that is tracking all of my purchases.  In the header
of the subform, I have a subtotal result which works fine.  When I try to
reference that value and actually display the subtotal on the main form
though, I get a #Name? error.  The subtotal on the subform ...

I have a form to add a record.  On this form, I have a combo box that when
clicked populates a listbox.  Well, all the fields on my add record form
are being created in the table EXCEPT the value in the list box.
Does anyone know why?