Data Not Showing in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've searched through some of the posts but have only seen the reverse of
this issue.

I have a table that I export data into from an excel spreadsheet, this data
then displays in my form and we edit it, add to it, change it, etc. It's
always been very simple for me to just retrieve the external data and it's in
the table and therefore in the form. Suddenly, even though 368 records are
in the table, none are showing up in the form??? I thought one post
indicated the Data Entry property of the form should be set to 'No', so I
double-checked and mind is already at no. And like I said, I've always done
this before, now suddenly my form is empty??

I greatly appreciate ANY help, thanks!!!!
 
NotIT said:
I've searched through some of the posts but have only seen the
reverse of this issue.

I have a table that I export data into from an excel spreadsheet,
this data then displays in my form and we edit it, add to it, change
it, etc. It's always been very simple for me to just retrieve the
external data and it's in the table and therefore in the form.
Suddenly, even though 368 records are in the table, none are showing
up in the form??? I thought one post indicated the Data Entry
property of the form should be set to 'No', so I double-checked and
mind is already at no. And like I said, I've always done this
before, now suddenly my form is empty??

I greatly appreciate ANY help, thanks!!!!
Click to expand...

Check for filters and double-check the RecordSource of your form.
 
"Allow Filters" says 'yes', but that's it?

I should've given more info too, the form's control source is a query, the
query is made up of two tables (Summary and Exception) and a few calculations
(which all seem to be working fine and have been working fine). The table
'Exception' has some look-up fields that pull values in from three other
tables, Underwriting, Appraisal, Third Party - there are relationships
between all of these tables. I didn't specifically add the Underwriting,
Appraisal and Third Party tables to the query the form is working off of,
because none of their fields display in the form, they are just look-up
tables. It occurred to me that maybe they did need to be added though, so I
did, then when I went to open my form there were no fields visible at all. I
think they were still there, but possibly hidden somehow?? It just looked
like a blank, grey form in the normal view. When I went and deleted those
look-up tables from the query, the form looked normal again, but still no
data from the table was showing up in it. I've used these look-up tables in
the past and never had them added to the query?

Thanks again, I appreciate any help!!!!
 
I also should've added, my 'Allow Additions' is set to 'yes'. I can't tell
if my query is read-only, how would I check this? Even if it was, I don't
understand why the data in my table (which the query runs off of) would not
be showing up in my form?

Thanks again!!!!
 
NotIT said:
"Allow Filters" says 'yes', but that's it?

I should've given more info too, the form's control source is a
query, the query is made up of two tables (Summary and Exception) and
a few calculations (which all seem to be working fine and have been
working fine). The table 'Exception' has some look-up fields that
pull values in from three other tables, Underwriting, Appraisal,
Third Party - there are relationships between all of these tables. I
didn't specifically add the Underwriting, Appraisal and Third Party
tables to the query the form is working off of, because none of their
fields display in the form, they are just look-up tables. It
occurred to me that maybe they did need to be added though, so I did,
then when I went to open my form there were no fields visible at all.
I think they were still there, but possibly hidden somehow?? It just
looked like a blank, grey form in the normal view. When I went and
deleted those look-up tables from the query, the form looked normal
again, but still no data from the table was showing up in it. I've
used these look-up tables in the past and never had them added to the
query?

Thanks again, I appreciate any help!!!!
Click to expand...

Well if you bind a form to a query that returns no rows then you get a form
with no data. If the structure of that query also makes it read-only (very
common with multi-table queries) then the detail section of the form will
appear completely blank as yours did.

The "normal" blank form you are used to seeing where you see all of your
controls empty is when the form is positioned at the "New Record" place
holder. That place holder does not exist in a RecordSet that is read.
 
NotIT said:
I also should've added, my 'Allow Additions' is set to 'yes'. I
can't tell if my query is read-only, how would I check this? Even if
it was, I don't understand why the data in my table (which the query
runs off of) would not be showing up in my form?
Click to expand...

Open the form in desing view and click the build button next to the
RecordSource property. That will take you to the design view of the query.
From there go to datasheet view and see if you can make edits. Most likely
you won't be able to.

A multi-table query can be based on tables that all have data in them and
still return zero rows. Your query is the problem. It is very unusual to
have a complex query feed a form and then still be able to edit data with
that form. The use of subforms is the better way to go.
 
Ok,I think I might "kind of" understand....do you mean BOTH tables that my
query is running off of have to values in them for the records to then show
up in the form? Is there a way to make it so the records will show up whether
both tables have values or not? What is happening is, we are downloading
info that is being stored in the Summary table (and then there are some
additional fields we fill out in that table) and then the Exception table has
blank fields we fill out - nothing is initially imported to that one. Does
that make sense?
 
NotIT said:
Ok,I think I might "kind of" understand....do you mean BOTH tables
that my query is running off of have to values in them for the
records to then show up in the form? Is there a way to make it so the
records will show up whether both tables have values or not? What is
happening is, we are downloading info that is being stored in the
Summary table (and then there are some additional fields we fill out
in that table) and then the Exception table has blank fields we fill
out - nothing is initially imported to that one. Does that make sense?
Click to expand...

Double-click the join line between the tables in the query designer and you
will get options that are self-explanatory in that regard. This might not
resolve the fact that your query is not editable though.
 
It actually did let me edit in that view? Basically we get a loan and then
we different categories of audits and information we need to add. So right
now, the user goes into the loan and then I have tabs where they first enter
loan info, then appraisal info, etc., etc. and I have a tab for each of these
sections. There are also 4 calculations that need to be done, that's why I
originally had the form running off of a query, so I could have calculated
fields. Then the table started getting too big so I split it into two tables
and joined them and had them in the query, etc. Can a subform work just like
a tab as far as the user is concerned? How is data stored in a subform then,
is it harder to run querys/reports off of the stored info? I'm a pretty
novice access user.....
Thanks again!!!
 
NotIT said:
It actually did let me edit in that view? Basically we get a loan
and then we different categories of audits and information we need to
add. So right now, the user goes into the loan and then I have tabs
where they first enter loan info, then appraisal info, etc., etc. and
I have a tab for each of these sections. There are also 4
calculations that need to be done, that's why I originally had the
form running off of a query, so I could have calculated fields. Then
the table started getting too big so I split it into two tables and
joined them and had them in the query, etc. Can a subform work just
like a tab as far as the user is concerned? How is data stored in a
subform then, is it harder to run querys/reports off of the stored
info? I'm a pretty novice access user.....
Thanks again!!!
Click to expand...

If your query is working and is letting you do updates then you should be ok
to stay with that. Have you tried editing data coming from the *other*
table yet?

A subform lets you see data from two sources and provides a link between
them on the linking fields. The editing is more straight-forward since in
that case each form (parent and child) is usually only dealing with a single
table. The linking automatically keeps the linking fields in synch.
 
Back
Top