'Enter the parameter' error message

[rushisaband]

Hi,
I'm a new Access user who is working with a form someone sent me. I have changed some of the fields in the table. In trying to use the form, I'm getting an "Enter the Parameter' error message. Can someone tell me the logic behind the statement and how I might fix it?

Thanks,

 

[jsv2002]

Is the forms datasource the table or a stored query?

If the forms datasource is a query and you have altered table names you need to update the query you will probably see a field in the query saying something like Expr [tablename].[oldfieldname] its asking you where those are when you try to open the form. And unless you have updated the record source for your text boxes in the form they will display #NAME as they no longer have a record source (you altered it)

Could also be some VB code perfoming lookups based on current information displayed but check if a query first as easier to solve.

Regards john

 

[rushisaband]

Thats one of the problems. I didnt construct the table and form and I'm not savvy enough, yet, to know. However, I believe from a table rather than a query.

Thanks!!

My mom is originally from Belfast!

 

[jsv2002]

Can you zip they database and attach so I could have a look? Belfast is 30 miles north nice place

regards John

 

[rushisaband]

Here it is. Thanks. I looked at the properties and they are very different from the original database.

 

[rushisaband]

Here is the original file before I changed the fields in the tables.

 

[jsv2002]

When I you having the problem as both versions seem to open fine on my system?

 

[rushisaband]

Hi,
In the first file I sent you, QRDatabase LitReview, if you try to add a code in Level 1 and level two. it doesnt show in the combox dropdown box. The 'Add' button is to add a new record and the Refresh button is to update the combo box.

For example, try adding 'car' in level 1 and vehicle in level 2 for both data bases and see what hapenns.

Thanks,
SAul

 

[jsv2002]

I have to be honest I don't find the form very well structured and I am not sure what you are trying to accomplish?

That said it may be exactly what was needed for its original purpose and I'm not being critical of the original author we all do things in different ways to accomplish our goals.

It would help to know what you are trying to modify the DB to do as the various combo boxes and tick boxes seem very confusing or if you could explain in more detail what the original database was used for?

Sorry can't be of more help John


P.S. Btw when I Add new record enter information and then click form refresh the information is in the combo drop down list to the left of level 1 just scroll down so can't really recreate the problem you are having.

 

[rushisaband]

The form is for a qualitative research project. The different levels are simply for different codes for different levels of generality. Hence my examples of 'car' for level 1 and 'vehicle' for level two. In a Sociological research vein, a level 1 might be 'Being flexible and gracious' and level 2 'Respecting the ex-spouse'.

I'm just trying to change the fields on the form from 'Level 1' to 'open coding' and 'level 2' to 'Focused coding'.

I appreciate your knowledge and help.

 

[jsv2002]

Well that explains why both the versions that I have work they are identical, no changes/differences between field names....

If you want to change a field name do it in the source table then any related queries (see attached has been altered to your names) also the control source of the text/combobox needs to be updated (done as well)

Compare what I have done with the original should give you the general idea.

good luck John.