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
|
|||
|
|||
vlookup in ms access
Hi
I'm not a programer, not aware of programming, I just started using ms access recently Can anyone help me in a simple language of creating vlookp in ms access in a form view if i have two combo boxes, and when i selected one value of combo box one, its corresponding value only reflected in next combo2 i have a master data for this like clomn1 clomn2 A1 c2 A2 c3 A2 c4 A1 c5 when I slecet A1 in combo 1 c2 and c5 only to be the options available in combo2 Please help me Regards Sujesh |
#2
|
|||
|
|||
vlookup in ms access
Sujesh
vlookup is available in Excel. Access doesn't have that function. However, Access doesn't need that function! Search on-line for "cascading comboboxes" to get an idea of how to do what you're describing... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "SJ" wrote in message ... Hi I'm not a programer, not aware of programming, I just started using ms access recently Can anyone help me in a simple language of creating vlookp in ms access in a form view if i have two combo boxes, and when i selected one value of combo box one, its corresponding value only reflected in next combo2 i have a master data for this like clomn1 clomn2 A1 c2 A2 c3 A2 c4 A1 c5 when I slecet A1 in combo 1 c2 and c5 only to be the options available in combo2 Please help me Regards Sujesh |
Thread Tools | |
Display Modes | |
|
|