Dynamic form Feilds

  • Thread starter Thread starter ChestMnednhlp
  • Start date Start date
C

ChestMnednhlp

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
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top