Text boxes without data show us

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

Guest

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
 
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
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
 
Sorry for my delay.

Please, look at data at bottom.
an

Sprinks said:
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
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 said:
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
Click to expand...
Click to expand...
 
Back
Top