Updated Data Not Shown on Form

[funderburgh]

I have a grade book application for our school with tabbed data sheet forms. Updated data on one data sheet does not appear on another.

The primary job of this application is to input student schedules. Virtually all of the entries in the schedule table are derived from lookup tables to standardize the input.

Included in the tabbed choices are sheets to input new Class and Teacher names to speed input of the schedules. The "Class Name" field in the schedule input is a combo box with the source control of the Class Name Table and the row control of that table's only field, Class Name.

During data entry, I can flip to the "Add New Class Name" form and add a record to that table. The new record shows on that data sheet and I can look behind the application at the table and see the record has been added.

I cannot for the life get the combo box on the New Schedule screen to show the new record. I have been throwing Requery and ShowAll Records on form and object events around like confetti, in macros and code.

The new data only shows if the application is completely closed and restarted.

Any ideas would be warmly welcome.

John Funderburgh

 

[pbaldy]

Have you requeried the combo box specifically, or just the form it appears on? You would need to requery the combo itself.

 

[funderburgh]

Thanks for responding.

Yes I have requeryed the snot out of that combo box, on entry, on exit, after update, on focus, on click - I would try "after Lunch" if it were there. I have also requeryed the subform the combo box is in, and the form that contains the subform in as many variations. I have also tried ShowAllRecords in the same wealth of variations. I have also varied these attempts between macros and code. Due to the number of records I have I get errors on the use of macros.

Ignorance is not really bliss.

John

 

[funderburgh]

Thanks for your response. I have not been able to accomplish this, and again it is syntax. Here is what I have:

Private Sub Class_Name_AfterUpdate()
Forms![Main Navigation]![Class Schedule Maintenance]![Class Schedule Maintenance Subform]![ClassNameBox].Requery
End Sub

The error I get is "Access cannot find the field Class Schedule Maintenance"

I have 9 inches of Access manuals and nowhere is there a syntax reference. I appreciate you assistance.

John Funderburgh

 

[pbaldy]

Here's a handy reference on the correct syntax:

http://www.mvps.org/access/forms/frm0031.htm

 

[funderburgh]

Thanks very much for the reply and the link. As I read the reference, I believe it says that my syntax should be:

Forms!Mainform!Subform1.Form!Subform2.Form!ControlName

I am still having trouble. What I had was:

Forms![Main Navigation]![Class Schedule Maintenance]![Class Schedule Maintenance Subform]![ClassNameBox].Requery

The difference seems to be the inclusion of the ".form" to the sub forms names. I tried:

Forms![Main Navigation]![Class Schedule Maintenance.form]![Class Schedule Maintenance Subform.form]![ClassNameBox].Requery

and

Forms![Main Navigation]![Class Schedule Maintenance].form![Class Schedule Maintenance Subform].form![ClassNameBox].Requery

In both variants I get the message that Access cannot find the field "Class Schedule Maintanance" (or "Class Schedule Maintenance.form").

So I still have a syntax error.

Any assistance is appreciated.

John Funderburgh

 

[funderburgh]

I am really grateful for the help on this issue. Pat's suggestion turned out to be on the money, although is an unexpected way. I have all the names right, but I do not have all of the levels in the syntax. The control I am trying to requery is a combo box in a sub-sub-sub form, in a sub-sub-form in a sub-form on a tabbed page of a main form (I started with just Form, sub, sub-sub, but then I changed to the tabbed approach which improved the useability of the application). Here is my question - what do I do with the tabbed page, would it be

MainForm!TabbedPage.page!Subform.form!SubSubform.form!SubSubSubForm.form!combobox.Requery

(Whew).

Thanks

John Funderburgh