|
| 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
August 21st, 2006, 04:11 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Combo Box and record selector
I have a combo box set up on my form that is used to select specific item
numbers. The form then shows all the information for that Item number. The combo box works perfectly except when someone clicks on the "next" or "previous" record selection buttons on the bottom of the form. When these buttons are clicked the item number in the combo box does not change. All of the other information does however change to the next record. How can i get the combo box value to also change when the record selectors are used? 
|
|
#2
August 21st, 2006, 04:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo Box and record selector
is the combo box property - allowEdits set to YES?
Ted W. wrote: I have a combo box set up on my form that is used to select specific item numbers. The form then shows all the information for that Item number. The combo box works perfectly except when someone clicks on the "next" or "previous" record selection buttons on the bottom of the form. When these buttons are clicked the item number in the combo box does not change. All of the other information does however change to the next record. How can i get the combo box value to also change when the record selectors are used? -- Message posted via http://www.accessmonster.com
|
|
#3
August 21st, 2006, 04:58 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo Box and record selector
Your combo is obviously an unbound control. Unbound controls know nothing of
the form's record source. If you want it to stay in sync with the data, you can use the form's Current event provided there is a text box bound to the field that matches the row source of the combo. If Me.NewRecord Then Me.MyCombo = Null Else Me.MyCombo = Me.txtBoundTextBox End If "Ted W." wrote: I have a combo box set up on my form that is used to select specific item numbers. The form then shows all the information for that Item number. The combo box works perfectly except when someone clicks on the "next" or "previous" record selection buttons on the bottom of the form. When these buttons are clicked the item number in the combo box does not change. All of the other information does however change to the next record. How can i get the combo box value to also change when the record selectors are used?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
