I am tempted to blurt out that I have a form which is exhibiting a couple o
f kinds of weirdness.   More professionally though, I will just say it exhi
bits "interesting" behaviour.

It is a complex form that I have been simplifying, or so I thought.  Among 
various changes, I have rid the form of 11 subs and thought I had made far 
better sense of it.

The form has a very simple table underlying it, but many subforms leading i
nto a couple of detail tables.  Among several behaviors, it is in one of th
ose detail tables that multiple records are occurring when they should not.

When I review existing records it seems pretty OK - except , and here is th
e first "interesting behavior", when I fiddle with values in one subform...
it protests that I am creating disallowed duplicate values, which I don't b
elieve I am, or it will tell me that control is not updatable.

After I noted that "interesting behavior", I started giving my form an over
all "health check" and saw that when creating new records, as I go from fie
ld to field adding data, it is jumping to new records in a detail table as 
I add info in those various fields - when those details should all be in on
e detail record.

I also noted that as I work with existing records, the various pages in a t
ab control look fine, but when I am on a new record, and here is where I ju
st can't resist the term "weirdness"...that first subform is totally missin
g from the screen.  If I go into design view, the subform is there, and If 
I go back to an existing record the subform is there, but...with a new reco
rd - poof. Go to an existing record again, and it's back...argggg.

I don't feel like this description is much good. so I have put the form and
 it's associated tables etc., into a mdb and made a half meg .zip I can ema
il.

Thanks in advance!

Charlie

I have solved one of the two issues...the subform which kept " hiding" or r
efusing to accept new records, but I still have the other issue...the unwan
ted creation of new records off subforms.

I know the remaining issue is something dumb.. the the hiding subform was f
rom something pretty stupid...needlessly basing a subform on two tables.  I
 can't explain what was going through my head.

Any ideas?

Charlie




> I am tempted to blurt out that I have a form which is exhibiting a couple
 of kinds of weirdness.   More professionally though, I will just say it ex
hibits "interesting" behaviour.
>
> It is a complex form that I have been simplifying, or so I thought.  Amon
g various changes, I have rid the form of 11 subs and thought I had made fa
r better sense of it.
>
> The form has a very simple table underlying it, but many subforms leading
 into a couple of detail tables.  Among several behaviors, it is in one of 
those detail tables that multiple records are occurring when they should no
t.
>
> When I review existing records it seems pretty OK - except , and here is 
the first "interesting behavior", when I fiddle with values in one subform.
.it protests that I am creating disallowed duplicate values, which I don't
 believe I am, or it will tell me that control is not updatable.
>
> After I noted that "interesting behavior", I started giving my form an ov
erall "health check" and saw that when creating new records, as I go from f
ield to field adding data, it is jumping to new records in a detail table a
s I add info in those various fields - when those details should all be in 
one detail record.
>
> I also noted that as I work with existing records, the various pages in a
 tab control look fine, but when I am on a new record, and here is where I 
just can't resist the term "weirdness"...that first subform is totally miss
ing from the screen.  If I go into design view, the subform is there, and I
f I go back to an existing record the subform is there, but...with a new re
cord - poof. Go to an existing record again, and it's back...argggg.
>
> I don't feel like this description is much good. so I have put the form a
nd it's associated tables etc., into a mdb and made a half meg .zip I can e
mail.
>
> Thanks in advance!
>
> Charlie
>