Basic question about forms...

[bladernr]

OK, this is driving me mad...

I have a form. That form contains a header which has some text fields
for ID number and name.
That form has a footer that simply contains a label that says something
like "This is a sample form".

The details field contains two tab objects. The first tab object
contains educational info split up into about 7 tabs. The second tab
object contains a couple other things, and has two tabls. Basically,
the form looks like this:

:Header:
ID Number First Name Last Name

etail:
-------------------------------------------------------------------
Tab1 | Tab 2 | Tab 3 | Tab 4 | Tab X

some stuff
some more stuff
some more stuff

-------------------------------------------------------------------
-------------------------------------------------------------------
TabA | TabB

Some extraneous fields
Some more extraneous fields

--------------------------------------------------------------------
:Footer:
THIS IS A SAMPLE FORM


The problem is that in design view, it looks EXACTLY like that, which
is what I want.
However, when I open it up for real, instead of looking like that, it
looks like this:

:Header:
ID Number First Name Last Name

etail:
-------------------------------------------------------------------
Tab1 | Tab 2 | Tab 3 | Tab 4 | Tab X

some stuff
some more stuff
some more stuff

-------------------------------------------------------------------
-------------------------------------------------------------------
TabA | TabB

Some extraneous fields
Some more extraneous fields

--------------------------------------------------------------------
--------------------------------------------------------------------
Tab1 | Tab 2 | Tab 3 | Tab 4 | Tab X

some stuff
some more stuff
some more stuff

-------------------------------------------------------------------
-------------------------------------------------------------------
TabA | TabB

Some extraneous fields
Some more extraneous fields

--------------------------------------------------------------------
:Footer:
THIS IS A SAMPLE FORM

So basically, the stuff in the Detail area is duplicated when the form
is executed, which is NOT how it is designed. Why does that happen,
and how do I fix it? I checked for duplicate objects, but there are
none... so Access is simply duplicating the stuff (It does thsi by
default. I can create a new form using the form wizard and it does
this on that form as well...)

Someone please save my sanity!!!

Thanks
Jeff

 

[bladernr]

Ok... Nevermind... I had thought that I set changed the form settings
from continuous form, but looks like that change didnt stick. it works
fine now... sigh...

 

[John Vinson]

So basically, the stuff in the Detail area is duplicated when the form
is executed, which is NOT how it is designed. Why does that happen,
and how do I fix it? I checked for duplicate objects, but there are
none... so Access is simply duplicating the stuff (It does thsi by
default. I can create a new form using the form wizard and it does
this on that form as well...)

What's the Form's Recordsource? I'm guessing that it's a Query joining
two tables, and that you are seeing duplicate data.

Bear in mind that starting your database design with your Form is
simply WRONG. The foundation of your database is your Tables; you must
have the tables and relationships set up correctly, before you even
start thinking about forms.

John W. Vinson[MVP]

 

[bladernr]

Well, on the one hand, I figured it out on my own. I thought I had set
the form to single form instead of continuous form in its properties...
I was mistaken.

I know what you mean about designing a db based on the form. The
database design is not my problem... my problem is using this tool
called Access ;-) heh. The DB itself consists of 4 tables joined
simply by a common ID that holds faculty credential information for a
local community college. My biggest challenge is using Access to
create the various forms and reports as I am NOT an Access pro by any
stretch of the imagination. In fact, I had tried to push them to PHP
or Python or some other web type language with a DB backend using MySQL
or something like that, but they insisted on Access because that is
what they use, and they were afraid of not having someone around to
maintain it in the future (Even though they have a full CS department
that has an actual Database Administrator degree and diploma program...
you would think that they could find some near graduation student in
need of a good project ;-) )

But be that as it may, the form has evolved anyway... heh... I have
another question for it, but in the interest of thread safety, I will
create a new thread for that.

I am learning more and more as I go, but Access is not something that I
use on an even semi-regular basis, so using what many of you consider
its obvious features is a bit of a challenge to me, even after reading
some books on using Access... heh.

Cheers
Jeff