new records will not show up in form

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

I have created a form using a query and I want to add new
records, and I want them to show up in the form. However,
when I add new records they only show up in the table from
which I created the query I'm using in the form. How can I
make the records show up in the form after I enter them?
I'm sure there is an easy solution but I'm stumped at this
point. Please help!
 
Jill said:
I have created a form using a query and I want to add new
records, and I want them to show up in the form. However,
when I add new records they only show up in the table from
which I created the query I'm using in the form. How can I
make the records show up in the form after I enter them?
I'm sure there is an easy solution but I'm stumped at this
point. Please help!
Click to expand...

Is your form in Data Entry mode? Check the DataEntry property in design view.
When set to true, the form opens blank and you can only see records entered in
the current session. To see records that existed prior to opening the form use
the "Remove All Filters" button in the toolbar. If you set the DataEntry
property to false then the form will show all records as soon as you open it.
 
Ah, you're binding your form to a multi-table query. This
will often not work as multi-table queries can easily become
read only depending on the structure. There is a help file
topic on what can make a query non-editable that you should
check out. Other than a simple lookup, you normally don't
want to bind data entry forms to multi-table queries.
 
Back
Top