Form doesn't show added table information

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

Guest

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.
 
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.
 
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?
 
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!
 
I dunno.
When you open the form in design view and look at the record source, exactly
what is in the property?
 
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!
 
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.
 
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."
 
You must log in or register to reply here.

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

Similar Threads

Separate Form 0
Update Two Tables Using One Form Contents 0
Update table when entry is saved 10
Multi-Table query data source won't allow edits in Form 7
Can't edit information on a form 1
Form for Parts-Tools Lists 0
forms based on queries 5
Using form and subform not connecting to two separate tables 0

Back
Top