Not all records displaying in form

[Okibi07]

Hi all,

Tried looking for this answer, and couldn't find my exact case available.

I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.

The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.

The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!

Thanks for your help!

 

[Okibi07]

I just changed the "Record Source" of my form from

SELECT Client.*, Memos.NoteDate, Memos.Notes AS Notes_Memos FROM Client INNER JOIN Memos ON Client.ID=Memos.[Client Name Foreign Key];


to

SELECT Client.*, Memos.NoteDate, Memos.Notes AS Notes_Memos FROM Client LEFT JOIN Memos ON Client.ID=Memos.[Client Name Foreign Key];

and that seemed to work! Thanks all!