J
justin
So, I posted this last friday, and I figure I'd repost it
with my additional comments after John had already made
some comments:
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:
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:
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:
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:
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:
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
with my additional comments after John had already made
some comments:
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:
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:
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:
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:
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:
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