Data entry field help

[bibbyd01]

I know this is a rediculously easy question, but I'm learning access as I go, and I've only just started. I'm trying to dismantle a query/form that someone else has put together.

When I open the query, it asks me to type the name of the person I want to run the query on. This refers to a field that no longer exists on the main table it's linked to, strKAM, and if I hit cancel then the query populates with all of the required data. How do I remove this pop up box as I can't figure it out?

 

[bibbyd01]

Nevermind, I've just figured it out!!

 

[John Big Booty]

Welcome to the forum.

You should be able to solve you problem, by opening the query in design view, and then delete the reference to the non existent field, from the criteria row.

What you are looking for will look something like;

[forms]![frm_Name]![FieldName]

One caveat however; copy the query, and play around with the copy of the query and not the original, so you at least have a fall back position should you break something in a big way.

 

[bibbyd01]

Thanks John, I made a backup of the entire database for just that reason!

It was actually in the parameters section, so once I removed this all was well!