How to view Records in a Form - Access 2007

[Guest]

I have set up a database consisting of 4 tables (all linked to one another
via relationships) and a form. I use the form to enter the data, which then
flicks all the information off to the relevant table.

However, I am not able to view all the records in form style. It
automatically opens with a blank form.

I have ensured under the form properties that Data Entry is set to "No" and
AllowAdditions, AllowDeletions, AllowEdits and AllowFilters are all set to
"Yes".

Please help!!!

 

[Allen Browne]

Is this form bound to a query that uses multiple tables?

If so, the query probably uses inner joins, with the consequence that
nothing shows up unless there are matching records in all the tables in the
query.

It may be possible to solve the problem by using outer joins. Double-click
the line joining the tables in the upper pane of query design. Access opens
a dialog with 3 options: choose #2 or #3 (depending what you need.) You will
have to watch any criteria you use as well. More details in this article:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

A better solution might be to bind the form to one tables only, or at least
only one table that you will try to append records to (even if there may be
lookup fields from another table.) Then use a subform for the related
records.

 

[Guest]

Hi Allen... No the form isn't bound to a Query. It isn't bound to anything
except the Tables I mentioned. I am not up with the technical side of this,
very much a beginner when it comes to this kind of thing...

I was an advanced user of Access 2003 and knew it like the back of my hand,
but 2007 seems to be a totally new program.

I just want each record I have entered to be shown on the one form, record
by record.

If I need to start creating Queries and/or Sub Forms, I'm going to have to
read up on them as I don't know what they are or how they work!

 

[Allen Browne]

I don't understand how you have the form bound to multiple tables.
What is in its RecordSource property?

 

[Rick Brandt]

Hi Allen... No the form isn't bound to a Query. It isn't bound to
anything except the Tables I mentioned. I am not up with the
technical side of this, very much a beginner when it comes to this
kind of thing...

Which is why you don't know that the wizard DOES bind your form to a query. It
might not be a saved query that you can see in the DB window, but it is a query
none the less. That is the only way to use data from more than one table in a
form.

Queries using more than one table are often not editable, making their use in a
form questionable.