being asked for a parameter that i cant find

Ok, I reckon there's a gremlin in this damn db...

For a form, i have a series of check boxes. One of these had a & symbol in the name, i originally had this working, but with some extra functionality added it no longer became possible, as it recognised it as a special character. The checkbox, and relating table reference was Inform_Q&FS I changed all references of it to Inform_QFS. However, im getting a parameter window pop up asking for the original reference. I've tracked it down to a point between a button being clicked and the begining of the following forms load Sub. The point of the button method triggering the parameter window is the line where the button changes the subform to the new form.

Here is the db..

Could somebody please take a look and see whats going on... im starting to get really frustrated with databases.

Also, any general comments regarding the db are welcome, as i'm assuming im doing things the right way there. and excuse the messy coding

It's in the frm_Change Recordsource. If you open the form and go to the recordsource and click the elipsis (...) to open it, then look through the included fields within the grid itself (the one in question shows up as Expr1).

Also, the way I quickly found it is using V-Tools Total Deep Search. It is a great tool for finding anything in your database, no matter where it is used. And the best part is it is free.

Find it at:

http://www.skrol29.com/dev/en_vtools.htm

my god your a legend bob... Thankyou so much...

any other tips after looking at the db?

btw, pw is bob to get through the login

ha, thats a complete coincidence btw..

Zaeed said:

my god your a legend bob... Thankyou so much...

any other tips after looking at the db?

btw, pw is bob to get through the login

ha, thats a complete coincidence btw..

Click to expand...

Yeah, I found that out pretty easily (that's why I use my encrypter tool and only store the encrypted value). I don't know if you knew this but a password stored in a table can easily be read by just doing something like putting a command button on a form that is bound to the table and use

MsgBox Me.txtPassword

and it will show it (NOT starred ***).

As for other tips, I can't really give any at this point. I had a hard day coding and my brain is pretty much spaghetti. So, I'm just looking at posts that don't require me to think too heavily at the moment

lol, not a problem...

I know that the password method i'm using isn't the most secure, it is basically just there to force people to log in as themselves.