Text boxes without data show us

Hi!

Based in a query, I have a form with combobox.
When form open, the combo is "blank". Don't show us any data. (Fine)
But the text boxes of the form, show us the numeric values of the first
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13604-text-boxes-without-data-show-us.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13604
record.
How is possible the text boxes don't show any data too, before choose an
option in combo, please?

Thanks in advance.
an


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

An,

The form will display the first record in the recordset defined by the
form's RecordSource property. If your combo box is Bound to a field in this
recordset (that is, it's ControlSource property is set to the name of a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13604
recordset field), the form will display its value. Since it is blank, I'm
guessing that either the combo box is not Bound to a field, or that the field
value is Null in the first record.

Hope that helps. If not, please post the following properties:

Form
RecordSource

ComboBox
RowSource
BoundColumn
ControlSource
ColumnWidths

Sprinks

"an" wrote:

> Hi!
>
> Based in a query, I have a form with combobox.
> When form open, the combo is "blank". Don't show us any data. (Fine)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13604
> But the text boxes of the form, show us the numeric values of the first
> record.
> How is possible the text boxes don't show any data too, before choose an
> option in combo, please?
>
> Thanks in advance.
> an
>

Sorry for my delay.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13604

Please, look at data at bottom.
an

"Sprinks" wrote:

> An,
>
> The form will display the first record in the recordset defined by the
> form's RecordSource property. If your combo box is Bound to a field in this
> recordset (that is, it's ControlSource property is set to the name of a
> recordset field), the form will display its value. Since it is blank, I'm
> guessing that either the combo box is not Bound to a field, or that the field
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13604
> value is Null in the first record.
>
> Hope that helps. If not, please post the following properties:
>
> Form F_Dis
> RecordSource Q_Dis
>
> ComboBox cboEstDis
> RowSource SELECT [Q_Dis].[Name], [Q_Dis].[Dis] FROM Q_Dis;
> BoundColumn 1
> ControlSource (whithout)
> ColumnWidths 10cm;2,5cm
>
> Sprinks
>
> "an" wrote:
>
> > Hi!
> >
> > Based in a query, I have a form with combobox.
> > When form open, the combo is "blank". Don't show us any data. (Fine)
> > But the text boxes of the form, show us the numeric values of the first
> > record.
> > How is possible the text boxes don't show any data too, before choose an
> > option in combo, please?
> >
> > Thanks in advance.
> > an
> >