it shows the data in datasheet view if posted into a query
How can it show the data in Datasheet View if, as you stated in your second post
the records are empty - there is no data in them
When the controls, even if empty, do not show up, the cause is, as DCrake stated, because "...it is a bound form and the underlying record source does not contain any records..."
and, and this is an important
and, the recordset is
Read-Only. This third thing has to also be true for this to happen.
If by
it shows the data in datasheet view if posted into a query
you mean that you can actually see the
textboxes, which are empty, this doesn't mean that the query can be updated. The real test is can you then add a record directly to the query? If not, the query is
Read-Only.
Allen Browne has an excellent short article on why queries are
Read-Only:
http://allenbrowne.com/ser-61.html
Aside from a
Read-Only query and
AllowAdditions being set to
No, other reasons for a form being
Read-Only include the
Recordset Type being set to
Snapshot or the user not having
Write Permission for the folder where the data resides.
Linq
;0)>