I have a subform (continuous form) with a Dlookup field that looks up information based on another field in the record.
The problem I have is that when a person inputs the information, code looks up the other information (which is part of the underlying query: and I can't put this field in the query) and inputs it automatically, but not the DLookup field. I have tried requerying just that field and it won't do it (perhaps because the record is not saved?) If I requery the entire form, it updates, but resorts the records which is confusing for the user.
Can I just requery this one Dlookup field?
The code I'm using is:
Forms!ALForm2!frmQuickEnter.Form![txtSheetTitle].Requery
I've also tried setting it as a control and requerying the control
The problem I have is that when a person inputs the information, code looks up the other information (which is part of the underlying query: and I can't put this field in the query) and inputs it automatically, but not the DLookup field. I have tried requerying just that field and it won't do it (perhaps because the record is not saved?) If I requery the entire form, it updates, but resorts the records which is confusing for the user.
Can I just requery this one Dlookup field?
The code I'm using is:
Forms!ALForm2!frmQuickEnter.Form![txtSheetTitle].Requery
I've also tried setting it as a control and requerying the control