Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Dynamic form Feilds

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChestMnednhlp - 12 May 2008 19:55 GMT
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.
Golfinray - 12 May 2008 20:58 GMT
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

> 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.
[quoted text clipped - 10 lines]
>
> any and all help would be greatly appreciated.
ChestMnednhlp - 12 May 2008 22:40 GMT
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.

> 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:
[quoted text clipped - 15 lines]
> >
> > any and all help would be greatly appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.