|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 1st, 2006, 07:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
List Box Help
On my form I have a subform and a list box. The subform was created from a
query. I am trying to get the List box to bring up the records from the query. If I highlight one of the records in the List box and then minimize the form and then open the subform the records appears. If I update the List box selection the subform does not change have to close it and reopen and then the records change. Why can't I get the records to appear when the subform is installed on main form and why can't I get records to update when changing the list box selection. Main form name: F-Phone-List Sub form name: F-Phone-List-SubList List Box: List0 
|
|
#2
September 1st, 2006, 08:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
List Box Help
In your After Update event of the List Box, put
Me.[F-Phone-List-SubList].Requery George wrote: On my form I have a subform and a list box. The subform was created from a query. I am trying to get the List box to bring up the records from the query. If I highlight one of the records in the List box and then minimize the form and then open the subform the records appears. If I update the List box selection the subform does not change have to close it and reopen and then the records change. Why can't I get the records to appear when the subform is installed on main form and why can't I get records to update when changing the list box selection. Main form name: F-Phone-List Sub form name: F-Phone-List-SubList List Box: List0
|
|
#3
September 1st, 2006, 08:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
List Box Help
Thanks - But that gives me an error message when on click on List Box that
can not find field name. "Jeff L" wrote: In your After Update event of the List Box, put Me.[F-Phone-List-SubList].Requery George wrote: On my form I have a subform and a list box. The subform was created from a query. I am trying to get the List box to bring up the records from the query. If I highlight one of the records in the List box and then minimize the form and then open the subform the records appears. If I update the List box selection the subform does not change have to close it and reopen and then the records change. Why can't I get the records to appear when the subform is installed on main form and why can't I get records to update when changing the list box selection. Main form name: F-Phone-List Sub form name: F-Phone-List-SubList List Box: List0
|
|
#4
September 1st, 2006, 08:40 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
List Box Help
Thanks - Got it to work .....
"Jeff L" wrote: In your After Update event of the List Box, put Me.[F-Phone-List-SubList].Requery George wrote: On my form I have a subform and a list box. The subform was created from a query. I am trying to get the List box to bring up the records from the query. If I highlight one of the records in the List box and then minimize the form and then open the subform the records appears. If I update the List box selection the subform does not change have to close it and reopen and then the records change. Why can't I get the records to appear when the subform is installed on main form and why can't I get records to update when changing the list box selection. Main form name: F-Phone-List Sub form name: F-Phone-List-SubList List Box: List0
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
