Hello all. Here's one for you: I have a pop-up form designed to enter
a new record in an underlying table. When I launch it on its own (no
other forms opened) it displays all the fields as it should. When I
launch it from the main form of my database however, it opens
mysteriously without any of the fields. Odder still, even simple text
labels (with no data field attached) fail to show. The record
selectors at the bottom of the pop-up indicate no records.
Essentially, one big gray window.

Anyone come across this before?

The truly maddening part is this: I have two other pop-up forms
designed to add records to two other underlying tables and they both
work fine when launched from the main form. I have studied them to the
last detail and given the glitchy form all the same properties.

Because I've created this monster over 4 years, I don't recall how I
got the two good ones to work (one launches from an "open form" macro,
the other from an event procedure...truly a patchwork job). I have
copied and modified both to no avail. Since I can easily recreate both
good pop-up forms to work for their unique tables, I am guessing the
problem lies with the glitchy pop-up and it's table.

My only guess is that somehow over the years, changing the properties
of the underlying table, there may be a discrepancy between the
primary key field in the underlying table, the same field on the
pop-up form and the same field on the main form.

I am now beginning to put the monster together from scratch, hoping
for better consistency. I'd feel guilty putting your intellects to
analyzing this in-depth (my Relationships window looks like Clark
Griswold's Christmas Lights). But if this problem rings any bells,
please give a holler!

Thanks and Happy Thanksgiving!!!

Hello Woo.

The Woo schreef:
Maybe your fields are just off screen. Try this:
1 - Open the form in edit mode and make it small, so you see other
windows too e.g. the database window.
2 - If my assumption was right you will not see your fields yet. To see
them use the scroll bars.
3 - Place the window where you want it to appear and save it.
4 - now you may return to full screen and try if it makes any difference.

I sure hope so.
Regards, Smiles.

Hi:
Interesting.
Send me a zip of your db and the name of the bad form and I'll look.

Good luck
Ira Solomon
On Tue, 22 Nov 2005 03:27:55 -0500, The Woo <***.www.co.> wrote:

Hi Woo

I have experienced this a couple of times. It has always been in conjonction
with an empty table - new instance of a table - and the form property "Allow
Additions" set to "No".
But, I understand that your table is loaded with data. So, my surgestion is
that you check your form property "Record Source" and/or Query, together
with the form property "Allow Additions" . It seems like the connection to
the underlaying table is broken.

Regards
Freddi