Form doesn't show added table information

M

Mariah

I have a form that is used to update a table. I recently added information
directly into the table (more members) and the form isn't recognizing the new
additions.

I have searched for an answer and have come up empty. Any assistance is
very much appreciated.
 
R

Rick Brandt

Mariah said:
I have a form that is used to update a table. I recently added information
directly into the table (more members) and the form isn't recognizing the new
additions.

I have searched for an answer and have come up empty. Any assistance is
very much appreciated.
Click to expand...

Your form is either based on a query that is filtering the records or it has a
filter applied.
 
M

Mariah

Hi Rick,
I checked and there are no filters. I also double checked and it is based
on a table and not a query.
While these valid solutions didn't resolve the problem might they help to
narrow down the solution?
 
M

Mariah

Hi Karl,

I added new records directly into the table. When I open the form I do not
see the records and the number of records is too low. I tried searching with
the binoculars but it doesn't come up with the new records.
If I go back to the table, then the records are still there.


Thank you for your time and assistance with this problem!
 
K

KARL DEWEY

I dunno.
When you open the form in design view and look at the record source, exactly
what is in the property?
 
M

Mariah

Gads, there -is- a query behind it. I am a newbie - and learning lots every
day about this wonderful program. I believe Rick was probably on the right
track.

Let's get more basic: If I want a form that will pull and update customer
name and address information from table1 and pull and update mailing
information (cards, newsletters, etc) from table2, and if I don't want the
requirement that we have to have a record in table2 in order to show and
update table1, should I do a subform or just have the form attach to multiple
sources. I think that is the question I need to have answered. Or maybe
that is just a starting point? I am so new that I don't know what I don't
know!

Thank you for your assistance!
 
M

Mariah

You are right! I am too new to know what I don't know! I found the query
and now trying to decide my next move. I just don't know if a subform would
be better or not.
 
K

KARL DEWEY

In normal cirumstances you can not use two sources for a form. But you can
use multiple tables in a query that is used as source for a form.
As you stated table1 has records for all but table2 may or may not have
matching records. In query design view (it is graphical) place table1 on the
left and table2 on the right. Click on table1 field that matches table2 and
drag to table2. Double click the connecting line and select the option that
says "Include ALL records from 'Table1' and only those records from 'Table2'
where joined fields are equal."
 
Top