Enter Parameter Value problem

[intern91]

Hello all

I have basic Access knowledge and I am working with 2007-2010 edition.
Everytime I open my form 'Project Data Sheet' I get a pop up to 'Enter Parameter Value' for 'Project Data Sheet.Anticipated Completion Date'.

Anticipated Completion Date(referred to as END), Anticipated or Confirmed Duration in Weeks (referred to as ACD) and Commencement Date (referred to as CD) are all sourced from a table called 'Project Data Sheet'.

CD is set to be a date to be selected by the user and ACD is number of weeks set by the user.
I created a formula in data-Control Source, for END, which is '=[CD]+7*[ACD]'.
The formula works fine, but as stated in the beginning this is providing me with a enter parameter value problem.

To be honest I don't know if this is causing the problem but it is the only control on my form that is giving me agro.

I have tried searching google for forum answers to help me but none that I could understand or implement myself without being in the conversation and asking.

Appreciate any help, trying to impress at work (they know I haven't any experience on access and I think they are testing me to see how well I can work with and learn programs I haven't used.

intern91

 

[burrina]

Take a look at this link, it may be helpful.
http://office.microsoft.com/en-us/access-help/why-does-access-want-me-to-enter-a-parameter-value-HA010274377.aspx

 

[intern91]

I have looked through the office help sections on this and they have not resolved this issue. I put the formula into the control on the form, so the table (as far as my understanding) takes the information from the form for each record.

Edit(20/08) that link only describes opening a form that has a query, mine is from a table. The only table references aswell is if the prompt appears when opening a table.

 

[intern91]

I have deleted the control in question on the prompt 'Anticipated Completed Date', closed and saved the form. And it is still asking me to enter a parameter value when I open the form again, the control isn't there that it is asking for. Still searching online for solutions, however nothing is presenting itself.

intern91

 

[burrina]

The query the form is based on has a parameter value or else some code on the form does, find it!

 

[intern91]

I am new to Access, so sorry if this is a stupid statement.
My form is based of a table, I don't have any queries in my database. I have tried looking at the form properties and its record source but so far haven't found anything out of place. The name on the record source is the same as the form and table. I have been searching it for a while but nothing has come to my attention.

When viewing the form's SQL, I couldn't find anything under Anticipated Completion Date that said or seem related to a parameter value.

intern91

 

[burrina]

If the form is based on our table and their is NO code asking for the date criteria then the problem is in the table itself. Do you have required set to yes or other criteria?

 

[intern91]

A friend of mine explained what you meant by the earlier post, the problem has now been solved. Found 2 sets of the record in the code, deleted and now it works.