a few questions about form design

[justin]

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?

Second question:

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

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.

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?

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.

I apologize for the length of this, but it's really
confusing and I can't figure it out.

Thanks in advance for any help, and if you need
clarification on anything, let me know. Thanks again

-Justin

 

[John Vinson]

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?

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?

Second question:

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

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.

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.

That's quite the correct way to do this.

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?

Nope, you're doing it exactly right!

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.

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]

 

[justin]

-----Original Message-----


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?

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.

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.

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.

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.

That's quite the correct way to do this.

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?

Nope, you're doing it exactly right!

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.

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]

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.

-justin