Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
List Box
- Thread starter Ajwebb
- Start date
chaufschild
MIS
Do you mean if you click on an item in a listbox it will open a form with that record displayed?
Chris Haufschild
chaufschild@hotmail.com
Chris Haufschild
chaufschild@hotmail.com
markgrizzle
Programmer
The simplest thing is to filter the form's underlying recordsource by the selected value in the listbox.
Me.RecordSource = "Select * from tblReports where ReportID = " & Me.lstReports & ";"
You'll need to enter the correct values for your bound column and listbox.
Mark
Me.RecordSource = "Select * from tblReports where ReportID = " & Me.lstReports & ";"
You'll need to enter the correct values for your bound column and listbox.
Mark
markgrizzle
Programmer
The simplest thing is to filter the form's underlying recordsource by the selected value in the listbox.
In the listbox AfterUpdate event, enter the following (error handlers, etc. removed for clarity)
Me.RecordSource = "Select * from tblReports where ReportID = " & Me.lstReports & ";"
You'll need to enter the correct values for your bound column and listbox.
Mark
In the listbox AfterUpdate event, enter the following (error handlers, etc. removed for clarity)
Me.RecordSource = "Select * from tblReports where ReportID = " & Me.lstReports & ";"
You'll need to enter the correct values for your bound column and listbox.
Mark
- Status
Similar threads
- Locked
- Question