Prev: (SELECT
Next: Query keeps looking for Query1 field
From: SJ on 28 Apr 2010 10:35
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

From: Jeff Boyce on 28 Apr 2010 10:40
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" <SJ(a)discussions.microsoft.com> wrote in message
news:63406AE2-9E4D-40EF-9A91-EEC2502745BD(a)microsoft.com...
> 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
>


 | 
Pages: 1
Prev: (SELECT
Next: Query keeps looking for Query1 field