N
NTXCoog
I'm having trouble w/my subform refreshing. My subform has several DLookups off text boxes on the main form.
At first I had the 2 forms as unbound forms. When I typed in a value in the text box on my main form, the DLookup results didn't show up on my subform. I tried requerying the Subform, Refreshing & Repainting the main form, but it still would not update. I know the DLookups were OK because when I put a static value in the text boxes on my main form, values showed up on my subform. If someone has a suggestion on why this didn't work, I'd appreciate it
So I changed the form & subform to be bound forms (even though none of the fields are used) & linked the two. That worked fine for when my DLookups come directly from the main form. Now my problem is I have a DLookup on the subform off a value in a textbox on the subform which has a DLookup off a textbox on the main form. The DLookup off the main form works, but my Dlookup off the subform's text box doesn't
Help!!
At first I had the 2 forms as unbound forms. When I typed in a value in the text box on my main form, the DLookup results didn't show up on my subform. I tried requerying the Subform, Refreshing & Repainting the main form, but it still would not update. I know the DLookups were OK because when I put a static value in the text boxes on my main form, values showed up on my subform. If someone has a suggestion on why this didn't work, I'd appreciate it
So I changed the form & subform to be bound forms (even though none of the fields are used) & linked the two. That worked fine for when my DLookups come directly from the main form. Now my problem is I have a DLookup on the subform off a value in a textbox on the subform which has a DLookup off a textbox on the main form. The DLookup off the main form works, but my Dlookup off the subform's text box doesn't
Help!!