Unable to find parameters

[ChrisSedgwick]

Hi,

When I open a form 'Project Details' it throws up a parameter box asking for an 'ID'

I searched throughout the database but I can't seem to find the cause for the parameter.

I've looked at my queries, forms and table and also relationships. I don't have a field that's linked to the form called 'ID'

I've attached a copy of my relationships. Is there a way I can see what causes the parameter. I thought it was only set in queries, however there are no parameters set up in my queries.

 

[gemma-the-husky]

look at the query for the form.
look at the properties (right-click the design window)

see if there is an old sort order, or similar that used ID

---
do the same with the properties for the form. there may be a filter, or sort order.

 

[namliam]

Or you could have some field called Project-id or Project id

that you didnt wrap in [], access will figure it as 2 fields ... since id isnt a field it will popup as a parameter.

 

[CJ_London]

Also if your form list and/or comboboxes check the rowsources

 

[ChrisSedgwick]

Thanks for all the responses.

I've located the issue - it was a problem with my Child Records - it was pointing to a field in an old table that was deleted, that had the field name 'ID'.

I've updated it to include the new 'ProjectID' which has resolved the issue.

Thank you.