x-post from previous question

So, I posted this last friday, and I figure I'd repost it
with my additional comments after John had already made
some comments:

-----Original Message-----
On Fri, 8 Apr 2005 10:26:43 -0700, "justin"
wrote:

Original post:
Ok, my first question:

I've created a form so users can enter information into
the relevant fields. But, I also removed a few fields, for
reasons I'll explain later, and now everytime I open the
form a prompt pops up asking me to "Enter Parameter Value"
for one of the fields I removed. My question is, why is
this happening, and how do I get rid of it?

John's response:

One possible place: did you perhaps include this field in
the Form's
Recordsource query, or in its Order By property? Or for
that matter
might it be the Control Source for a control, or part of
the RowSource
of a combo or listbox?

My response to John:

The field it's asking about is the "name" field. So, no
the name field isn't in the form's recordsource query, or
the Order By property, it's not part of a rowsource for a
listbox, and I don't think its part of a control source
for a control. I'm not exactly sure how to check that last
one, but I'm pretty sure that's not the problem. I tried
changing the data entry property on the subform from no to
yes, and that got rid of the message, but I couldn't enter
data into the subform with it set to yes. So I still
haven't solved this problem....

Another problem I have with this name field is that
everytime I open up the form to enter the data, I still
get the "Enter Parameter Value" prompt, but after I click
the "ok" button, there will be the word "Documents" in the
name field textbox. I have no idea where this comes from,
and I can't seem to get rid of it. If you can help me with
this one, it would be appreciated.


Original post:
Second question:

Like I said before, I removed three fields from the
original form, and created a subform with those removed
fields.

Johns response:

But did you remove them *FROM THE TABLE*? Forms don't
store data, and
forms don't have fields: they have *controls*, tools
which are bound
to table fields.

My response to John:

Yes, the three fields were removed from the table and I
then created a new table with those three fields. This new
table is what the subform is created from.


Original post:

I should probably start out by saying that those fields I
removed are used to make comments about the rest of the
information, to record the date the comments were made,
and to record the name of the person who made the comments.
The comments only apply to individual documents and not
all the documents in the database. So, I've created a
tblcomments table to store those 3 fields. There is also
an ID field which is related to the ID field in the
information table. By doing this I'm assuming that the
comments being entered into the subform, will only show up
if you're looking at the related documents information.

Johns response:
That's quite the correct way to do this.

original post:

One of my questions is; is this the right way to set
this up, or should I put the comments, commentdate, and
name fields into the main information table, and get rid
of the tblcomments table and it's subform?

Johns response:

Nope, you're doing it exactly right!

original post:

The other problem I'm having with this subform, is that
when I go to enter comments into the comments field on
the form, I get a message saying "This property is read-
only and can't be set." Why is this? If I click the "ok"
button, I can then enter information into the field.


Johns response:

Where is the comments field? Is it a Textbox on the
subform, bound to
the [Comments] field in the Notes table? WHat is the
Recordsource
property of the Subform, and its Master and Child Link
Fields? What's
the Control Source of the textbox that's giving you this
message?

John W. Vinson[MVP]

my response to John:

The comments field is in the tblcomments table. It is a
textbox on the subform with the control source property,
the comments field from the tblcomments table. The
recordsource property of the subform is the tblcomments
table. There are no Master and Child Link fields under the
properties for the subform. Should there be? If I open up
the tblcomments table and click on properties for the
comments field, the Master and Child Link fields are
blank. Should that be? Actually, all the Master and Child
Link fields are blank in the tblcomments table. I don't
quite understand what you mean by "What's the Control
Source of the textbox that's giving you this message?"
Thanks for the help.

Some additional questions I've come up with:

note: I still haven't figured out solutions to any of the
problems listed above.

1) How do I get my subform, to change along with the main
form?
I can enter information into all the fields, but when I
click the right arrow on the bottom of the main form, it
will change the main form to blank, and it will also
change the subform to a blank form. But if I click the
left arrow on the bottom of the main form to go back to
the first set of information I entered, the main form will
go back, but not the subform. The subform will only show
that there is only 1 of 1 records, even though I entered
information into the subform.

2) How do I get my ID field in my comments table, which is
related to the DocumentID field (autonumber) on the main
table, to be the same number as the autonumber? I want it
set up so everytime you enter data into the main table,
which has the autonumber, the comments that go along with
that document stay with that document. So then when you go
to edit information for a document, you can see previous
comments made on that document or add new comments about
the new data being entered.

Thanks for the help

-justin

On the menu click Tools, Analyze, Documenter.
Select the form. Click OK. That will tell you how the
field is used.
-----Original Message-----
So, I posted this last friday, and I figure I'd repost
it
with my additional comments after John had already made
some comments:

-----Original Message-----
On Fri, 8 Apr 2005 10:26:43 -0700, "justin"
wrote:

Original post:
Ok, my first question:

I've created a form so users can enter information into
the relevant fields. But, I also removed a few fields,
for
reasons I'll explain later, and now everytime I open the
form a prompt pops up asking me to "Enter Parameter
Value"
for one of the fields I removed. My question is, why is
this happening, and how do I get rid of it?

John's response:

One possible place: did you perhaps include this field
in
the Form's
Recordsource query, or in its Order By property? Or for
that matter
might it be the Control Source for a control, or part
of
the RowSource
of a combo or listbox?

My response to John:

The field it's asking about is the "name" field. So, no
the name field isn't in the form's recordsource query,
or
the Order By property, it's not part of a rowsource for
a
listbox, and I don't think its part of a control source
for a control. I'm not exactly sure how to check that
last
one, but I'm pretty sure that's not the problem. I tried
changing the data entry property on the subform from no
to
yes, and that got rid of the message, but I couldn't
enter
data into the subform with it set to yes. So I still
haven't solved this problem....

Another problem I have with this name field is that
everytime I open up the form to enter the data, I still
get the "Enter Parameter Value" prompt, but after I
click
the "ok" button, there will be the word "Documents" in
the
name field textbox. I have no idea where this comes
from,
and I can't seem to get rid of it. If you can help me
with
this one, it would be appreciated.


Original post:
Second question:

Like I said before, I removed three fields from the
original form, and created a subform with those removed
fields.

Johns response:

But did you remove them *FROM THE TABLE*? Forms don't
store data, and
forms don't have fields: they have *controls*, tools
which are bound
to table fields.

My response to John:

Yes, the three fields were removed from the table and I
then created a new table with those three fields. This
new
table is what the subform is created from.


Original post:

I should probably start out by saying that those fields
I
removed are used to make comments about the rest of the
information, to record the date the comments were made,
and to record the name of the person who made the
comments.
The comments only apply to individual documents and not
all the documents in the database. So, I've created a
tblcomments table to store those 3 fields. There is also
an ID field which is related to the ID field in the
information table. By doing this I'm assuming that the
comments being entered into the subform, will only show
up
if you're looking at the related documents information.

Johns response:
That's quite the correct way to do this.

original post:

One of my questions is; is this the right way to set
this up, or should I put the comments, commentdate, and
name fields into the main information table, and get rid
of the tblcomments table and it's subform?

Johns response:

Nope, you're doing it exactly right!

original post:

The other problem I'm having with this subform, is that
when I go to enter comments into the comments field on
the form, I get a message saying "This property is read-
only and can't be set." Why is this? If I click the "ok"
button, I can then enter information into the field.


Johns response:

Where is the comments field? Is it a Textbox on the
subform, bound to
the [Comments] field in the Notes table? WHat is the
Recordsource
property of the Subform, and its Master and Child Link
Fields? What's
the Control Source of the textbox that's giving you
this
message?

John W. Vinson[MVP]

my response to John:

The comments field is in the tblcomments table. It is a
textbox on the subform with the control source property,
the comments field from the tblcomments table. The
recordsource property of the subform is the tblcomments
table. There are no Master and Child Link fields under
the
properties for the subform. Should there be? If I open
up
the tblcomments table and click on properties for the
comments field, the Master and Child Link fields are
blank. Should that be? Actually, all the Master and
Child
Link fields are blank in the tblcomments table. I don't
quite understand what you mean by "What's the Control
Source of the textbox that's giving you this message?"
Thanks for the help.

Some additional questions I've come up with:

note: I still haven't figured out solutions to any of
the
problems listed above.

1) How do I get my subform, to change along with the
main
form?
I can enter information into all the fields, but when I
click the right arrow on the bottom of the main form, it
will change the main form to blank, and it will also
change the subform to a blank form. But if I click the
left arrow on the bottom of the main form to go back to
the first set of information I entered, the main form
will
go back, but not the subform. The subform will only show
that there is only 1 of 1 records, even though I entered
information into the subform.

2) How do I get my ID field in my comments table, which
is
related to the DocumentID field (autonumber) on the main
table, to be the same number as the autonumber? I want
it
set up so everytime you enter data into the main table,
which has the autonumber, the comments that go along
with
that document stay with that document. So then when you
go
to edit information for a document, you can see previous
comments made on that document or add new comments about
the new data being entered.

Thanks for the help

-justin
.

If you are being prompted, the field is referenced somewhere on the form.
You'll need to find it. The most likely suspects are the filter and order
properties.
"justin" wrote in message
...
So, I posted this last friday, and I figure I'd repost it
with my additional comments after John had already made
some comments:

-----Original Message-----
On Fri, 8 Apr 2005 10:26:43 -0700, "justin"
wrote:

Original post:
Ok, my first question:

I've created a form so users can enter information into
the relevant fields. But, I also removed a few fields, for
reasons I'll explain later, and now everytime I open the
form a prompt pops up asking me to "Enter Parameter Value"
for one of the fields I removed. My question is, why is
this happening, and how do I get rid of it?

John's response:

One possible place: did you perhaps include this field in
the Form's
Recordsource query, or in its Order By property? Or for
that matter
might it be the Control Source for a control, or part of
the RowSource
of a combo or listbox?

My response to John:

The field it's asking about is the "name" field. So, no
the name field isn't in the form's recordsource query, or
the Order By property, it's not part of a rowsource for a
listbox, and I don't think its part of a control source
for a control. I'm not exactly sure how to check that last
one, but I'm pretty sure that's not the problem. I tried
changing the data entry property on the subform from no to
yes, and that got rid of the message, but I couldn't enter
data into the subform with it set to yes. So I still
haven't solved this problem....

Another problem I have with this name field is that
everytime I open up the form to enter the data, I still
get the "Enter Parameter Value" prompt, but after I click
the "ok" button, there will be the word "Documents" in the
name field textbox. I have no idea where this comes from,
and I can't seem to get rid of it. If you can help me with
this one, it would be appreciated.


Original post:
Second question:

Like I said before, I removed three fields from the
original form, and created a subform with those removed
fields.

Johns response:

But did you remove them *FROM THE TABLE*? Forms don't
store data, and
forms don't have fields: they have *controls*, tools
which are bound
to table fields.

My response to John:

Yes, the three fields were removed from the table and I
then created a new table with those three fields. This new
table is what the subform is created from.


Original post:

I should probably start out by saying that those fields I
removed are used to make comments about the rest of the
information, to record the date the comments were made,
and to record the name of the person who made the comments.
The comments only apply to individual documents and not
all the documents in the database. So, I've created a
tblcomments table to store those 3 fields. There is also
an ID field which is related to the ID field in the
information table. By doing this I'm assuming that the
comments being entered into the subform, will only show up
if you're looking at the related documents information.

Johns response:
That's quite the correct way to do this.

original post:

One of my questions is; is this the right way to set
this up, or should I put the comments, commentdate, and
name fields into the main information table, and get rid
of the tblcomments table and it's subform?

Johns response:

Nope, you're doing it exactly right!

original post:

The other problem I'm having with this subform, is that
when I go to enter comments into the comments field on
the form, I get a message saying "This property is read-
only and can't be set." Why is this? If I click the "ok"
button, I can then enter information into the field.


Johns response:

Where is the comments field? Is it a Textbox on the
subform, bound to
the [Comments] field in the Notes table? WHat is the
Recordsource
property of the Subform, and its Master and Child Link
Fields? What's
the Control Source of the textbox that's giving you this
message?

John W. Vinson[MVP]

my response to John:

The comments field is in the tblcomments table. It is a
textbox on the subform with the control source property,
the comments field from the tblcomments table. The
recordsource property of the subform is the tblcomments
table. There are no Master and Child Link fields under the
properties for the subform. Should there be? If I open up
the tblcomments table and click on properties for the
comments field, the Master and Child Link fields are
blank. Should that be? Actually, all the Master and Child
Link fields are blank in the tblcomments table. I don't
quite understand what you mean by "What's the Control
Source of the textbox that's giving you this message?"
Thanks for the help.

Some additional questions I've come up with:

note: I still haven't figured out solutions to any of the
problems listed above.

1) How do I get my subform, to change along with the main
form?
I can enter information into all the fields, but when I
click the right arrow on the bottom of the main form, it
will change the main form to blank, and it will also
change the subform to a blank form. But if I click the
left arrow on the bottom of the main form to go back to
the first set of information I entered, the main form will
go back, but not the subform. The subform will only show
that there is only 1 of 1 records, even though I entered
information into the subform.

2) How do I get my ID field in my comments table, which is
related to the DocumentID field (autonumber) on the main
table, to be the same number as the autonumber? I want it
set up so everytime you enter data into the main table,
which has the autonumber, the comments that go along with
that document stay with that document. So then when you go
to edit information for a document, you can see previous
comments made on that document or add new comments about
the new data being entered.

Thanks for the help

-justin