Form will not show newly added records.....

[Andrew.Champion]

I have a db that tracks student information and grades by class number. I am using a form to enter all student information and grades into two tables. I have entered a new class of students using the form and everything has posted to the table without issues. When i go to open the form none of the newly added records will show up. I have ran the query and it shows the new class number along with the other class numbers. I have verified that the form properties data entry is set to NO. Any help with this issue is very much appreciated and I thank you in advance. I am using access 2010.

 

[John Big Booty]

Is the form's Data Entry property set to Yes(True) by any chance?

 

[John Big Booty]

...

I have verified that the form properties data entry is set to NO. Any help with this issue is very much appreciated and I thank you in advance. I am using access 2010.

Sorry ignore me Carry on.

 

[John Big Booty]

Have you got any code or macros attached to the Form's On Load event?

 

[Andrew.Champion]

Have you got any code or macros attached to the Form's On Load event?

I have nothing on the on load event. If it helps i just ran my query alone and it will not show the new additions either.

 

[John Big Booty]

The data is definitely storing in the table?

I'm presuming you have no criteria in your query?

Is your form bound directly to the underlying table, or through the auspicious of your query?

 

[Andrew.Champion]

The data is definitely storing in the table?

I'm presuming you have no criteria in your query?

Is your form bound directly to the underlying table, or through the auspicious of your query?

No criterias, and i dont understand auspicious of the query
I have both tables on the query linked by primary key and showing multiple fields of each table. All data is stored on table yes

 

[John Big Booty]

... i dont understand auspicious of the query
...

Is the form linked directly to the table? Or is the Form linked to the table via the query?

 

[Andrew.Champion]

Is the form linked directly to the table? Or is the Form linked to the table via the query?

It is running through the query

 

[John Big Booty]

Can you post a copy of the query in design view?

 

[Andrew.Champion]

can i email it to you

 

[John Big Booty]

Just attach it to your next post using the Paper clip button;

 

[Andrew.Champion]

My internet feed will not allow it sorry
What are you looking for maybe I can tell you what I have and that will work

 

[John Big Booty]

I'd like to see how the query is structured.

 

[Andrew.Champion]

I hope this works

 

[Andrew.Champion]

View attachment 40993
I hope this works

Did I lose you on the thread, if I did I appreciate all the help you have provided

 

[John Big Booty]

From that screen shot I can see that those two tables are in no way normalised.

I'm guessing that data is not going in the same table as the query is searching.

I would suggest that you read up on data normalisation and re-think your table structure, you will then find that there is less scope for the confusion that I believe is currently happening. This tutorial will also be of help.

 

[John Big Booty]

Did I lose you on the thread, if I did I appreciate all the help you have provided

You lost me to that thing called sleep