parameter requested

[chadlmiller]

OK, I am working on Access 2007, I am familiar with the Access 200 concepts but haven't worked it since.

I added a new field to an Issues Tracker MS Template table. I copied the "comments" field and added a new field called "Resolution_Comments"

I added it to the "Issues" Form

Now when ever I start up the DB or open the Issues form I receive this Enter Parameter Value Msgbox:
"Issues.Resolution_Comments" with either Ok or Cancel options. If I select OK, it goes away and form opens, if I cancel the form will not load.

I need to simply remove it and I would like to understand how I created it.

Need more info let me know.

Chad

 

[GKChesterton]

Is the form based on the table? Or on a query? If it's a query, perhaps you need to include your new field in the query.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[chadlmiller]

After inspecting the Db folder, it would appear that the Form is based off of the Table. I say this because I can see only one Query in the system called "Open Issues" which apparently is associated to a Macro of "Browse All Issues Macro"

I inspected teh only Query and I do not see the field "Resolution_Comments" within the query.

 

[dhookom]

I added it to the "Issues" Form" what is the Control Source of the text box on your form? If it is "Issues.Resolution_Comments", try remove the "Issues."

Duane
Hook'D on Access
MS Access MVP

 

[chadlmiller]

Ok so now I really have done it....


Here is the latest development

I forgot to tell you that I entered the new field into a TabControl area. then I attempted to fix the situation by deleting the following table fields:
Resolution_Comments
Resolution_Comment

and so I copied an existing field called "Due Date" and added it to the form and renamed it "Resolved Date".

So now everytime the form loads, I get "Parameter Required" Msgbox on all three fields
Resolution_Comments
Resolution_Comment
Resolved Date

Without Starting this over, is there a way to remove these required Parameter msgboxes and how SHOULD I add a to a table a new column because the tradition method of adding a column seems to not be working for me.

Chad

 

[dhookom]

I think you are confusing controls on forms and fields in tables. A field is a column in a table or query that allows you to store a piece of information. A control on a form or report such as a text box displays the value from a field or possibly an expression.

A control might have a Control Source property which identifies the field from the form or report Record Source. Typical Control Sources might be:
[tt][blue] [ResolvedDate] [/blue][/tt]
or
[tt][blue] =DateDiff("D",[IssueDate],[ResolvedDate])[/blue][/tt]

If you are getting prompted for a value then your fields in your form's Record Source don't match something in your Control Source(s). Find and fix it so the match.

Duane
Hook'D on Access
MS Access MVP

 

[GKChesterton]

There's always downloading a fresh version of the Issues Tracker MS Template, I suppose!

You can do this: Go to Tools --> Analyze --> Documentor. Select all options for all objects and run the report. From there, go to the File menu and Export as .RTF document. You now have a searchable document that fully (though awkwardly) describes the entire database. Search on your problem words and you should be able to identify the trouble spots.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​