data in forms

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

Guest

Data entered in a form shows up in the table, but disappears from the form.
How can I make the data accessible through the form as well?
 
Please describe in more detail under what circumstances your data
"disappears". Three common circumstances are:

- The form's DataEntry property is set to Yes, which will permit new entries
but not show existing records.

- The form's RecordSource is set to a query rather than the table itself,
and the query is filtering the records by some criteria.

- A continuous form has a combo box whose RowSource is changed by code,
usually from a previous combo box. For example, a County combo box, filtered
by a State selection to show only those counties in the selected state.
Since the combo box can have only one RowSource at any given time, rather
than a different one for each row, previous selections that are no longer in
the RowSource cannot be displayed.

Sprinks
 
The DataEntry property was the problem. Thanks!

Sprinks said:
Please describe in more detail under what circumstances your data
"disappears". Three common circumstances are:

- The form's DataEntry property is set to Yes, which will permit new entries
but not show existing records.

- The form's RecordSource is set to a query rather than the table itself,
and the query is filtering the records by some criteria.

- A continuous form has a combo box whose RowSource is changed by code,
usually from a previous combo box. For example, a County combo box, filtered
by a State selection to show only those counties in the selected state.
Since the combo box can have only one RowSource at any given time, rather
than a different one for each row, previous selections that are no longer in
the RowSource cannot be displayed.

Sprinks
Click to expand...
 
Back
Top