Subform changes as mainform changes

[Ken Curtis]

Hi!
I have built a form (General Log) attached to a table (General Log Table).
There are 6 fields (AutoNumber, Date, Type of Contact, Staff Name, Content,
Followup). The form occupies the top half of the screen.

The bottom half of the screen holds a subform which shows (is supposed to
show)the entire contents of the General Log Table so people can scroll
through this subform to see ALL of the General Log entries in the General Log
Table.

I have tried multiple times to do this, and, have come close to pulling it
off, but the subform insists on resetting to the view of the main form (one
record only) whenever the main form is set to accept a new record: the
subform stops showing ALL of the records, and just shows what the main form
is showing: a blank record

This is very frustrating. So: my question is:what am I doing wrong here?

Thanks.

 

[John Spencer]

It sounds as if the Link Child Fields and Link Master Fields property of the
subform control is NOT blank.

If you don't want the subform linked to the General Log records you need to
clear the link properties of the subform.

That said, this sounds like a strange design to me.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Golfinray]

Something has to be wrong with your table or query setup. Forms and subforms
are designed to be one-to-many, say, one realtor, many houses. You are
trying to basically get the subform to show the entire log and it should only
show the records related to the record in the mainform. Try creating TWO
forms that can be placed side by side so that users can see the specific file
and the general log at the same time.

 

[Ken Curtis]

John.
Thanks for your input. You are correct: the field property fields were NOT
blank.

You note that it sounds like a "strange design to me". OK. But how else can
I have all the records in the General Log available to staff members to look
at while they respond? It just seemed like a good way of doing it, John, but
if there is a better way of doing it, and if you know that way, PLEASE tell
me!

 

[John Spencer]

Sorry, I didn't mean to imply that you were wrong to do it this way.

If it works for you then it works for you.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Ken Curtis]

No problem, John. I was sincere. My idea isn't working, so I tought if you
had a better/different/usual-way-its-done idea then I would sure love to know
what it is.

All I want to do is have the bottom half of the screen show me all the
entries in the table to which the form at the top of the screen is writing
records. I want people to be able to scroll through the records to read what
is there, but not be able to change the contents of the records.

It all sounds so simple. And it may very well be so. But not to me,
obviously.

Regards

 

[John Spencer]

You might consider using a list box to show the other records. The limitation
there is that you could not have more than 64K records and would be limited to
displaying just one line of data.

If you use a subform, then you need to set the locked property of all the
controls on the subform to True which will keep the users from modifying the
record in the subform.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County