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

  • Thread starter Thread starter KissMeBeard
  • Start date Start date
K

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
 
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
 
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
 
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?
 
Thanks Allen worked thanks again for your help!

Allen Browne said:
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?
Click to expand...
 
Back
Top