can't input data

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?
 
J

John Vinson

What have I done, and how do I undo it?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top