Dynamic form Feilds

Okay I am working with a access database and I am trying to format the form
to display certain information based on a combo box answer.

so I've garnered so far I need to go to on current event of the form and
type in my commands (I planned in using expression builder)

but I'm having trouble with the coding. I can't even get a simple label to
change text on click event.

the basic concept that I am trying to do is on combo field value "dark" then
display feilds "screw in light bulb" and "turn on light switch" (these are
examples of course and not the actual field names.)

any and all help would be greatly appreciated.

To use a combo as a filter first use the wizard to make your combo and pick
the field you want to lookup. Then go into the afterupdate event and type:
Me.filter = "[myfield] = """ & Me.yourcombobox# & """"
Me.filteron=true

"ChestMnednhlp" wrote:

Okay I am working with a access database and I am trying to format the form
to display certain information based on a combo box answer.

so I've garnered so far I need to go to on current event of the form and
type in my commands (I planned in using expression builder)

but I'm having trouble with the coding. I can't even get a simple label to
change text on click event.

the basic concept that I am trying to do is on combo field value "dark" then
display feilds "screw in light bulb" and "turn on light switch" (these are
examples of course and not the actual field names.)

any and all help would be greatly appreciated.

I'm not sure filtering is really what I am looking for, perhaps a rephrase...

when a certain state is selected in a combo box lets say - georgia
then I want two other feilds to become visible - "peaches" and "southern
hospitality" so the user can input information.

"Golfinray" wrote:

To use a combo as a filter first use the wizard to make your combo and pick
the field you want to lookup. Then go into the afterupdate event and type:
Me.filter = "[myfield] = """ & Me.yourcombobox# & """"
Me.filteron=true

"ChestMnednhlp" wrote:

Okay I am working with a access database and I am trying to format the form
to display certain information based on a combo box answer.

so I've garnered so far I need to go to on current event of the form and
type in my commands (I planned in using expression builder)

but I'm having trouble with the coding. I can't even get a simple label to
change text on click event.

the basic concept that I am trying to do is on combo field value "dark" then
display feilds "screw in light bulb" and "turn on light switch" (these are
examples of course and not the actual field names.)

any and all help would be greatly appreciated.