can't input data

  • Thread starter Thread starter Valerie
  • Start date Start date
V

Valerie

I don't know what I've done, but I've messed something up.
I have a form with a subform. It was working just fine
after I designed it, but now it has changed to where, if
there is no data, all I can see in form view is the
header. In design view, everything looks just fine. I have
to input data in the original tables from which the
recordsource query is drawn in order for any data to show
up in the form view screen. And then when it does show up,
I do not have the option of adding a new record in the
form itself (however, I do have the option of adding a new
record in the subform). What have I done, and how do I
undo it?
 
What have I done, and how do I undo it?
Click to expand...

Somehow you've made the Form's Recordsource into a query that is not
updateable. A Form with a non-updatable recordsource won't let you add
new data or edit existing data; if that recordsource also has no
records, all controls disappear from the form as you see.

Perhaps you could post the recordsource Query to a message here, to
see if someone can figure out why it's not updateable.
 
Back
Top