Form asks for query criteria on loading (listbox problem)

[daninthemix]

I have a listbox that uses a query to reference a value in the current form. The problem is for some reason Access is trying to fill this listbox before even showing the form, so I get prompted to manually enter the query criteria when it should be picking it up from the form.

This is bizarre because it's only just started doing it. I've removed the listbox and created it again, but no help. I have listboxes such as this all over the place, but this particular one has just started playing up! Why?

 

[Rickster57]

Query

Make sure the reference is named correctly. Sounds like the query can't find the reference you refer to in the criteria.
You may want to consider posting the db so someone can take a look at it..if that's possible for you to do.

 

[daninthemix]

Rick, the reference is definitely named correctly.

There's a field with associated textbox called 'Fault Ref', and the box prompts me to enter forms!support!Fault Ref which is right there on the form!

 

[Rickster57]

Name

I'm just making sure that the Control Source of that textbox and the "Name" under Other is the same....this is a very common mistake...especially by me in the past

 

[daninthemix]

So do you have any other ideas Rick? I can email the database to you but would prefer not to post it.

Thx

 

[Rickster57]

email

Check your private messages for my email address.
I will look at it as time permits

 

[Rickster57]

Fault Ref Field

Interesting. The Fault Ref was indeed named correctly in the query. Renaming it and even recreating it resulted in the same prompt. Went into the After Update of several of the text boxes and on typing Me. no ques came up.

Created a new form in Design View. Copied all the fields from the Support form (which was corrupted) and pasted them into the new form and assigned it's data source accordingly. Opened the new form with no hitches.