Find a record on my form based on the value I selected in my combo

[KissMeBeard]

Hi

I would consider my self a novice user of Access so bear with me if I am not
using the correct terminology!

I have recently migrated from access 2003 to access 2007 however on my
database which was created in access 2003 there is a combo box which "Finds a
record on my form based on the value I selected in my combo box" This is not
functioning correctly in 2007 but is working correctly on 2003?? When I
select the record it does not update the form??

Any ideas would be much appreciated!!


Mark

 

[Allen Browne]

Code in Access 2007 does not run unless your database is in a trusted
location.

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

More hints on converting to Access 2007:
http://allenbrowne.com/Access2007.html

 

[KissMeBeard]

Hi Allen

Thanks for your reply!! It just so happens that I read this info, and tried
it before I posted the query, it had no effect! Any other ideas? Thanks in
advance .

MArk

 

[Allen Browne]

Could be bad references:
http://allenbrowne.com/ser-38.html

If *no* code runs, I suspect it is still the trust issue.

If one particular procedure fails, add the line:
Debug.Print "Ran at " & Now()
above the first line in the procedure.
Then open the Immediate Window (Ctrl+G), and see if the information is
printed there when you expect it to run.

If so, you need to debug the procedure.
If not, why isn't it firing at all? Is the Event property unset?

 

[KissMeBeard]

Thanks Allen worked thanks again for your help!

Could be bad references:
http://allenbrowne.com/ser-38.html

If *no* code runs, I suspect it is still the trust issue.

If one particular procedure fails, add the line:
Debug.Print "Ran at " & Now()
above the first line in the procedure.
Then open the Immediate Window (Ctrl+G), and see if the information is
printed there when you expect it to run.

If so, you need to debug the procedure.
If not, why isn't it firing at all? Is the Event property unset?