How to handel three sub form

[tekaccess]

Hi

I am using one combobox(unbound) on my main form. I want to hide and unhide the subform according to my selection on combo box.

I am trying like this:
afterupdate()
if combo83.column(0) then
me.subform1.visible=true
else
if combo83.cloumn(1) then
me.subform2.visible=true
end if
end if

i tryied same on form_current()

column (0) is ok but
column(1) is not working

thanks

 

[dhookom]

Are you attempting to retrieve the value of the combo box? What is the Row Source of the combo83 (not a good name)?
How many columns does your combo box contain?

Column(0) returns the value of the first column of the Row Source. Column(1) returns the value of the second column of the Row Source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tekaccess]

Hi
Thanks for prompt response. Actually i just want to display and hide the subform against the value which i get from combo box (sigle value-undounded)
Its work fine with coulumn(0) but there is no change for column(1) and so on.

Thanks

 

[missinglinq]

Double posting is really kind of frowned on here and in most other fora. People responding to one post don't always realize that a problem's been solved on the other posting, or that a solution they may propose has already been tried and failed, and so they waste time.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!