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?
How can I make the data accessible through the form as well?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
"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
G
Guest
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