Prev: Captor - Microcap System
Next: Access 2003 query error -1, 0
From: troy23 on 7 Sep 2009 11:48
I have a form bound to a query. It loads fine.

On that form there is a text box which does a DLookup to sum and get a
total from another query. It only shows the result if I click on the
text box. It should show as soon as the form loads.

Pls help


From: Salad on 7 Sep 2009 12:16
troy23 wrote:
> I have a form bound to a query. It loads fine.
>
> On that form there is a text box which does a DLookup to sum and get a
> total from another query. It only shows the result if I click on the
> text box. It should show as soon as the form loads.
>
> Pls help
>
Does your ControlSource for that field look something like
=Dlookup("FieldName","TableName","ID = 1")
or something else?
From: troy23 on 7 Sep 2009 13:27
The query actually filters on the ID so the text box just says Dlookup
("[TotalPaid]","qryPaymentsTotals")

This works fine in all other versions of Access, but not in 2007.





On 7 Sep, 17:16, Salad <o...(a)vinegar.com> wrote:
> troy23 wrote:
> > I have a form bound to a query. It loads fine.
>
> > On that form there is a text box which does a DLookup to sum and get a
> > total from another query. It only shows the result if I click on the
> > text box. It should show as soon as the form loads.
>
> > Pls help
>
> Does your ControlSource for that field look something like
>         =Dlookup("FieldName","TableName","ID = 1")
> or something else?

From: troy23 on 7 Sep 2009 14:02
This is now solved - I installed Service Pack 2 and it solved the
issue.

Thanks


On 7 Sep, 17:16, Salad <o...(a)vinegar.com> wrote:
> troy23 wrote:
> > I have a form bound to a query. It loads fine.
>
> > On that form there is a text box which does a DLookup to sum and get a
> > total from another query. It only shows the result if I click on the
> > text box. It should show as soon as the form loads.
>
> > Pls help
>
> Does your ControlSource for that field look something like
>         =Dlookup("FieldName","TableName","ID = 1")
> or something else?

 | 
Pages: 1
Prev: Captor - Microcap System
Next: Access 2003 query error -1, 0