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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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

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" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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

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?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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

Thanks Allen worked thanks again for your help!

"Allen Browne" wrote:

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?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KissMeBeard" wrote in message
...
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