SubForm not updating after crash

[gpsmith]

I started in on a payroll database for practice, and was working to integrate a subform. My Access is not letting me use wizards, and so I was manually assembling everything. For one glorious hour, the form worked exactly as desired, and then Access crashed. I've rebuilt the system as near as I can recall, but the SubForm isn't quite linking the way it should.

In practice, the user would:

• Select a student (and the form automatically updates the ID)
• Select a supervisor associated with that student
• Select an account associated with the supervisor

These three pieces of information would uniquely define the contract we're talking about, and the subform should update with the remaining parts pulled from the contract table. All the selection portions work, but the subform isn't updating with anything beyond a Name error. Can someone help me get straightened out?

Thanks!

[June7]

Is this the frmLookupContract and frmContractSubForm subform arrangement?

Why is the subform not bound? Can't set Master/Child Links for unbound forms.

Why bind the main form and not display data from its records on itself?

I've never seen anyone attempt a form/subform design like this. Using expressions in UNBOUND subform to display data from the main form record. Very odd. And the expressions are wrong in that they reference the table name, not form name. Actually, =[Parent].[Account] works.

This could be a single form in Continuous view with the search controls in form header. Review http://www.allenbrowne.com/ser-62.html

[gpsmith]

The organization was the way my mind unwrapped the problem of "part of the form I'm using for searching for a unique records" and "part of the form updating a unique record". Missed the binding in the manual insert, so that wasn't intentional (and glad you pointed it out).

Always happy to consider easier approaches, so Ill look into the link you provided, thanks!