I keep a left side  navigation form open all the time in my app.  On it
is a list of all the open forms in the remaining MDI space.  When a new form
is opened, it adds itself to that list.  When the user closes the form, it
removes itself.

Hi, all;
Many times I've answered questions like this in the queries and tabledesign
forum:
I have a table like this:

This may sound a strange question - but I'm having a mental blockage.
I have one table which contains multiple questions and a second table that
contains multiple company names.
I need a method of displaying the questions on a form and being able to

I have a control that the user enters a number. I am trying to insure that
the number entered is at least 5. I tried to create a macro with conditions
that runs a messagebox and then the gotocontrol actions. The messagebox works
but not the gotocontrol. I then wrote an event ...

I have an Access 2003 interface project (form) where in each
record, a designer can open a combo box (Row Source: SELECT [PageType].
[PageTypeID], [PageType].[PageType] FROM [PageType]) and choose one of
a small number of page types:

I am trying to add several different values in a field and display them on a
report. For Example: Field name: products (several different products) Filed
name prodID (number assigned to product):
The fields that I want to add up are the ones that relate to age, sex, and

I have a form with two linked subforms on it. The first subform is quite long.
When I open the form I want the focus of the subform to be on the first
field. Quite often it is half way along and I have to scroll all the way back
to the start before I can enter a record.

I hope this doesn't sound too simplistic a question to ask of the great minds
here!
I've created a form which I will use as a switchboard (it's not one of the
inbuilt access switchboards).  I want to add a office clipart item onto it

Dear All,
Thank you for taking the time to read this post. I am having a major problem
is regards to list/combo boxs in access forms. I am creating a form from a
table and I keep getting an error message Saying Record source "then lists my

My Access 2007 (on Windows XP) is starting to behave weirdly since a few
days. I have already tried to re-install the whole system, but the
problem still come back.
I have a form with a subform in datasheet view. The subform gets

I've been trying to find a way to get Access to default to the last entered
value for a combobox in a field.
Here's the scenario: User inputs data into multiple combo boxes on form,
saves record and moves to next "blank" record. When the new record shows up,

I want to open my subforms from my main forms by using command buttons.  My
command buttons work well and successfully open the appropriate subforms,
however, the parent-child or one-to-many relationship is not maintained as it
is if I work off of a nested view where both parent and ...

I swear I posted this question yesterday but I can't find the thread for the
life of me.
I have a linked imported excel file that displays on a form. There is only
one column in the Excel file of words I need to keep in alphabetical order.

I am using Access 2003, Window XP Pro.  I use a form control name
RequisitionNumber on two separate form, what I hope to achieve with your
assistance is not make the RequisitionNumber text be shown on the form that
the number does not relate to. In other words, the number is ...

I am new to forms and macro's etc so apologies in advance if there is a
simple solution to this.
I have a basic requirement where a form shows a related record number e.g.  
a students record displays the ID of a related student - in my case this