zpotok
asked on
Help with 2007 Access Template Combo Box Record Search
The following MS Office 2007 Access Template <Faculty> link:
office.microsoft.com/en-us
...has a nice record search displaying the selected record in a textbox (actually this is pretty generic in most of their 2007 templates). I've been trying to incorporate this into my form but I want nothing to do with embeded macros. Stick with VBA.
Can someone please provide the After Update and On Got Focus for their cboGoToContact combo so it will show in the textbox exactly as in the Faculty Details Form on the Template using event procedures instead of the macros. .
office.microsoft.com/en-us
...has a nice record search displaying the selected record in a textbox (actually this is pretty generic in most of their 2007 templates). I've been trying to incorporate this into my form but I want nothing to do with embeded macros. Stick with VBA.
Can someone please provide the After Update and On Got Focus for their cboGoToContact combo so it will show in the textbox exactly as in the Faculty Details Form on the Template using event procedures instead of the macros. .
ASKER
Where is Database Tools > Macro? I'm using Access 2010
for Access 2010, click Design, it will be at the Right most part of the ribbon, but
as we have discussed before, this is a known bug in A2010.
wait till i get home and i will convert it using A2007 and post the VBA codes here.
as we have discussed before, this is a known bug in A2010.
wait till i get home and i will convert it using A2007 and post the VBA codes here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks (once again) for your help.
sure wish they would come out with a A2010 service patch....
sure wish they would come out with a A2010 service patch....
The Office 2010 SP1 should be coming out soon.
open form in design view,
from ribbon
Database tools > Macro
Convert from's macro to Visual Basic