Perameter Value

[IMO]

I have form in my db that is bringing up 3 boxes asking for different parameter values. I have not added any of these and wonder if anyone can tell me how to get rid of them. I have no idea what query is creating them as I do not have anything in the criteria fields in any of my queries. Any assistance anyone can provide would be appreciated as I am not at all literate with this program. Thank-you

[NeoPa]

Search for the values it asks for within your SQL.
So if you have the form bound to a query, open the query in SQL view and search for it there.

This usually happens when a field is used which doesn't exist.

For instance, if you have a table [tblTable] with a field [Field] and you have a query

SELECT [Feeld]
FROM [tblTable]

then, because [Feeld] is NOT a field but a spelling or typo error, Access prompts the user to provide a value for it when the query runs.

[MMcCarthy]

Open the form in design view.

Open the properties window and under the data tab what is the record source of the form.

If it is a SELECT statement copy and paste it here.

If it is a saved query then open the query in design view. Change the view to sql and copy and paste it here.

I would guess that it's looking for values from somewhere.

[IMO]

Open the form in design view.

Open the properties window and under the data tab what is the record source of the form.

If it is a SELECT statement copy and paste it here.

If it is a saved query then open the query in design view. Change the view to sql and copy and paste it here.

I would guess that it's looking for values from somewhere.

The record source on the form is a table, however, the table does not have the values it is looking for. I have gone through every query, every report, every property box but these two values are nowhere to be found.

[MMcCarthy]

The record source on the form is a table, however, the table does not have the values it is looking for. I have gone through every query, every report, every property box but these two values are nowhere to be found.

Go to each control (field, textbox, combobox, etc.) on the form in design view. Open the properties window and look at the following for each.

In the data tab

Control Source
Default Value

In the Other tab

Name

In each textbox the Control Source should be the field you expect it to be, if not what is it?

Is there any value in the default value refering to another field or value?

Is the 'Name' what you expect it to be?

Next question ...

Is there a subform on your main form?

[IMO]

Go to each control (field, textbox, combobox, etc.) on the form in design view. Open the properties window and look at the following for each.

In the data tab

Control Source
Default Value

In the Other tab

Name

In each textbox the Control Source should be the field you expect it to be, if not what is it?


Is there any value in the default value refering to another field or value?

Is the 'Name' what you expect it to be?

Next question ...

Is there a subform on your main form?

I have checked all of the above and everything is as it should be. Any more suggestions? Thanks so much

Yes, there is a subform but I have checked it as well.

[MMcCarthy]

I have checked all of the above and everything is as it should be. Any more suggestions? Thanks so much

Yes, there is a subform but I have checked it as well.

Have you checked the subform object itself

Check for child parent relationship

Check if there's a filter

[IMO]

Have you checked the subform object itself

Check for child parent relationship

Check if there's a filter

Yes, have checked the above as well - no filters - not sure where to find the child relationships. There are no relationships when I click on the relationship icon. The values it is asking for is something that was removed and renamed Does the db have a memory that cannot be cleared even if you totally delete all instances of the original field when it gets renamed??

[NeoPa]

No.
But it does sound as if you haven't deleted all references properly.
Check for anything to do with the deleted items which may still be hanging around in the design somewhere.

[IMO]

No.
But it does sound as if you haven't deleted all references properly.
Check for anything to do with the deleted items which may still be hanging around in the design somewhere.

I have checked each and every instance where this was several times. I don't know where to check any more. I do have a marcro which runs a findskater field but it also points to the correct field. This value is looking for something from the table which is just not there.

[NeoPa]

Try this :-
In the database window, try Tools / Analyse / Documenter.
Select as much as possible to produce everything it's got.
Copy and paste the results (RTF) into MS Word for its searching facilities.
Search for the strings that you can't find.

[MMcCarthy]

Yes, have checked the above as well - no filters - not sure where to find the child relationships. There are no relationships when I click on the relationship icon. The values it is asking for is something that was removed and renamed Does the db have a memory that cannot be cleared even if you totally delete all instances of the original field when it gets renamed??

In the design of the main form go to the subform and open the properties window. Under the data tab you will find two fields like link child fields and link master fields. What is in there?

You said the form is based on a table. Did you open the propeties window on the form and check what was in the record source property under the data tab?