By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

My forms will not show the newly added records.....

P: 3
I have a database that tracks student information and grades. I am using a form to enter data and the form will post to a table as information is entered. The form is using a query to select students by class number. I have entered a new class number with 16 students into the form. The table has received all information that has been entered. Now when I try to load the new class number in the form none of the records will show. When i attempt to re enter the information it creates a new primary key to each student entered and then doubles the entries. I have checked the data entry and NO is selected. When i run the query it will show the all the class numbers entered to include the new one. Any help with this will be much appreciated and thank you in advance.
Mar 12 '12 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,492
I have entered a new class number with 16 students into the form.
I only know what you include in the question, but that tells me you have a Student form (for entering Student information). How then, can it make sense to say that you've entered a class into this form?

The problem here will almost certainly involve something about the design of your form. A part that you haven't shared with us. You need to give reasonable thought to your question before posting. We can't help if you don't tell us much.
Mar 12 '12 #2

P: 3
i have a field per record to input the class number, then i have a query to filter the records by that class number
Mar 12 '12 #3

Expert Mod 15k+
P: 31,492
I assume you mean you've entered 16 new students, all from the same new class, into the table via the form. Furthermore, when you proceeded (presumably in the same session without closing and re-opening the form) to select the new class to filter on, none of the records shows.

You have a query to apply the filtering. That's clear. We know nothing of this query though, except that it's a query. Normally, this might indicate that a Me.Requery() call is required when applying the filter, but it would be unusual for that to be required within the same form. Might be worth a try anyway.

Otherwise it seems to me there are two options :
  1. Look in Example Filtering on a Form to see how to filter more simply without the need of a separate QueryDef object.
  2. Post the SQL of your filtering query as well as the SQL the form is bound to (it's RecordSource) so that we have something to work with.

My personal preference would be #1, as that's less complicated and will involve you learning a new ability that you will be able to use extensively if you continue to design Access databases.
Mar 12 '12 #4

P: 759
First of all, for me sound as a normalization problem.
If I understand well the Andrew's table (and form as well) has this fields (maybe not only):
ClassNumber , StudentName
(or something like this.

Have you, Andrew, a table named (maybe) Classes and other table named (maybe) Students ? Or you have the class number and the students in the same table ?
Mar 13 '12 #5

Expert Mod 15k+
P: 31,492
for me sound as a normalization problem.
I suspect that's because Andrew failed to explain his situation very well originally. It seems clearer now. I would not read from his explanation that there is a normalisation problem necessarily (I can't say what else is in the database of course, just what he's shared). There is no reason to assume the [Class] field, or information, he says is entered is anything but a correct reference to a class. This could be an FK if a Class table exists, or it could even be a non-qualified reference if no further information about classes is required in the database. We're not in a position to know at this stage.
Mar 13 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.