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
|
|||
|
|||
comboboxes on subform
I have a subform with two comboboxes. The contents of the second is
determined by what is selected in the first. I finally have this working. The control sources for each combobox are in the same table and the data is properly being captured in the table. The problem is that when I scroll from one record in the primary form to the next, the second combobox in the subform appears empty when a value had been selected. For example, I select fish in the first combobox, and goldfish in the second combobox in the subform and then go to the next record (of the main form) and select dog then husky in the two comboboxes. I then go back to the previous record. The first combobox still displays fish, but the second is blank. However the data is still in the underlying table. Is there some sort of event that I can do to tell it to display the current values in the control source? TIA |
#2
|
|||
|
|||
comboboxes on subform
I had this same problem about a year ago.. I REALLY try not to be a hack, BUT
the best I could do was to put a text box linked to the same datasource over the combo box (but not the arrow on the combo box). Don't let them type directly into the text box... You're basically making it look like a combo box. I know, it's very far from ideal, but I worked on it for a few days and got input from co-workers.. it was the best we could do. *** this would be easy in VB.. "papa jonah" wrote: I have a subform with two comboboxes. The contents of the second is determined by what is selected in the first. I finally have this working. The control sources for each combobox are in the same table and the data is properly being captured in the table. The problem is that when I scroll from one record in the primary form to the next, the second combobox in the subform appears empty when a value had been selected. For example, I select fish in the first combobox, and goldfish in the second combobox in the subform and then go to the next record (of the main form) and select dog then husky in the two comboboxes. I then go back to the previous record. The first combobox still displays fish, but the second is blank. However the data is still in the underlying table. Is there some sort of event that I can do to tell it to display the current values in the control source? TIA |
#3
|
|||
|
|||
comboboxes on subform
That is an interesting idea. Would the background of the text box be
turned off or something so that when the dropdown is first selected it can be seen? Or does the text box just display would was just selected? |
#4
|
|||
|
|||
comboboxes on subform
One way I do (which also overcome the problem with cacaded ComboBoxes in
CtsFormView) is to use 2 ComboBoxes on top of each in place of your second ComboBox (i.e. totalling 3 ComboBoxes): 1 ComboBox is unfiltered and the second one filtered. The unfiltered one sit on top and on its GotFocus Event, re-query the filtered ComboBox and send the Focus to the filtered ComboBox. -- HTH Van T. Dinh MVP (Access) "papa jonah" wrote in message ups.com... I have a subform with two comboboxes. The contents of the second is determined by what is selected in the first. I finally have this working. The control sources for each combobox are in the same table and the data is properly being captured in the table. The problem is that when I scroll from one record in the primary form to the next, the second combobox in the subform appears empty when a value had been selected. For example, I select fish in the first combobox, and goldfish in the second combobox in the subform and then go to the next record (of the main form) and select dog then husky in the two comboboxes. I then go back to the previous record. The first combobox still displays fish, but the second is blank. However the data is still in the underlying table. Is there some sort of event that I can do to tell it to display the current values in the control source? TIA |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unlinked subform | Don Barton | Database Design | 5 | May 20th, 2005 12:23 AM |
Subform on Subform problem | JohnB | Using Forms | 4 | April 10th, 2005 12:52 PM |
Subform Refresh Problem (but only with an unbound combo box control) | Barry Skidmore | Using Forms | 1 | December 21st, 2004 01:19 AM |
dealing with a subform record when it's "dirty" | Paul James | Using Forms | 8 | October 17th, 2004 08:45 AM |
Need help with cascading combos | Tom | Using Forms | 19 | July 1st, 2004 11:11 PM |