If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Find a record on my form based on the value I selected in my combo
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 |
#3
|
|||
|
|||
Find a record on my form based on the value I selected in my c
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 |
#4
|
|||
|
|||
Find a record on my form based on the value I selected in my c
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 |
#5
|
|||
|
|||
Find a record on my form based on the value I selected in my c
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 |
Thread Tools | |
Display Modes | |
|
|