By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Perameter Value

P: 5
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
Oct 28 '06 #1
Share this Question
Share on Google+
11 Replies


NeoPa
Expert Mod 15k+
P: 31,470
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
Expand|Select|Wrap|Line Numbers
  1. SELECT [Feeld]
  2. 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.
Oct 28 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 28 '06 #3

P: 5
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.
Oct 29 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Oct 29 '06 #5

P: 5
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.
Oct 29 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Oct 29 '06 #7

P: 5
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??
Oct 29 '06 #8

NeoPa
Expert Mod 15k+
P: 31,470
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.
Oct 29 '06 #9

P: 5
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.
Oct 29 '06 #10

NeoPa
Expert Mod 15k+
P: 31,470
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.
Oct 29 '06 #11

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Oct 29 '06 #12

Post your reply

Sign in to post your reply or Sign up for a free account.