ComboBox RowSource Disappears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am putting a new ComboBox on my form and am having a strange problem where
the RowSource values disappears!

When I am in DesignView, I can see it in the Properties Window, but when I
go to FormView, the RowSource is gone. If I past it into the RowSource, while
in FormView, it works, but then when I go back to DesignView, it's gone again!

I have tried saving the form, when I can see it; creating a different
combobox; compact & repair; and even importing all the objects into a new
database, all with no luck. I even tried creating a blank form and copied the
ComboBox to that form, and it works there!

I do have a lot of controls, on several tabs, on this main form on which I
am trying to create the control. Could there be some kind of control limit I
am hitting on this form?

I appreciate any thoughts.

Thanks,
Larry
 
I did some more checking in the form and found I have 300 controls of the
following numbers and types on the form and it's subforms (including the bad
one). BTW, it's Access 2003.

Form: frmItinerary
TextBox 31
Label 52
TabControl 1
Page 10
OptionGroup 3
OptionButton 11
CheckBox 9
SubForm 9
CommandButton 3
Line 1
Form: subfrmApproval
Label 4
TextBox 4
Form: subfrmAirTransportation
Label 17
TextBox 14
CheckBox 2
Form: subfrmAccomodation
Label 12
TextBox 12
Form: subfrmRentalCar
Label 9
TextBox 9
Form: subfrmLimoService
Label 8
TextBox 8
Form: subfrmOtherGround
Label 9
TextBox 9
Form: subfrmVisa
Label 9
TextBox 9
Form: subfrmInCountry
Label 12
TextBox 9
Form: subfrmChanges
Label 7
TextBox 7
 
Well, I noticed my code to count the controls had a mistake and handled
ComboBoxes wrong. Of course I found it after I posted, so here's the correct
count (even though it probably doesn't matter).

Form: frmItinerary
TextBox 18
Label 52
TabControl 1
Page 10
OptionGroup 3
OptionButton 11
ComboBox 13
CheckBox 9
SubForm 9
CommandButton 3
Line 1
Form: subfrmApproval
Label 4
TextBox 3
ComboBox 1
Form: subfrmAirTransportation
Label 17
ComboBox 4
TextBox 10
CheckBox 2
Form: subfrmAccomodation
Label 12
TextBox 11
ComboBox 1
Form: subfrmRentalCar
Label 9
ComboBox 1
TextBox 8
Form: subfrmLimoService
Label 8
ComboBox 1
TextBox 7
Form: subfrmOtherGround
Label 9
TextBox 7
ComboBox 2
Form: subfrmVisa
Label 9
ComboBox 3
TextBox 6
Form: subfrmInCountry
Label 12
TextBox 7
ComboBox 2
Form: subfrmChanges
Label 7
ComboBox 3
TextBox 4
 
Back
Top