A2003 mdb Form field doesn't automatically populate in A2010

[wilpeter]

The subform is bound to the lookup table tblCourses. If you change data in the subform you change it in that table.

The values in tblCourses are set by committee before each semester and cannot change. Course #2124 in Semester 134 will never be changed. Next year, #2124 will be in a different Semester and have a different set of fees.

You need to input the desired value into the main form Course Fee textbox which is bound to field in tblRegister.

Yes, the only input form is REGISTRATIONS which feeds tblRegister. All other tables and forms are support/lookups.

You can use code to populate that textbox with the standard fee and it will be editable. Right now I don't see that box get populated.

That's the $64,000 question: How to populate that field!


Unless something happened when it was Zipped, the field should (presently) reflect the Member Fee because it is directed to by a macro.

Include the CrsFee field as a column (can be hidden) in the course combobox then code in the combobox AfterUpdate event can set value of the textbox be referencing combobox column. I only use VBA:

Me.CrsFee = Me.RefNb.Column(2)

I'll have to examine this and see if I understand it. Tomorrow I may be fresher!
Thanks for your input.

[wilpeter]

OK, examined and tested it. I added CrsFee (from tblCourses) to the RefNb combo box. Then I set the After Update property of the CrsFee to =RefNb.Column(2).
It doesn't use the correct value and worse, it remains when the next Registration record is called. It may be, after all, that what we had for 9 years has disappeared!
Thanks for the hope, though.

[June7]

The code should be in the AfterUpdate event of RefNb combobox, not textbox. In the combobox AfterUpdate event property select [Event Procedure]. Click the ellipses (...) to open the VBA editor. Type code in the procedure.

I think macro can also accomplish.

[wilpeter]

Well ain't that somethin' for sore eyes! An AfterUpdate [Event Procedure] to the RefNb Combo Box! Yes, it works fine and thank you June7 for your patience with me. Makes we wish I'd learned Code back when we converted our db2 DOS program to Windows. Too late for me now, I'm 75. Have a great day!

[June7]

Never too late! I'm 59+ and back in school learning networking tech.

[wilpeter]

Meanwhile, is there a way to chain (in the Event Procedure/code) a GoToControl to follow that after update code?

[June7]

I use SetFocus method.

Code in the AfterUpdate to set focus on a control.

Me.controlname.SetFocus