Getting Value as label Caption

[Naveen Marapaka]

Hi dear, I have 2 tables and I made a query to get the Dsum of a field in 2 tables.



as Select Sum(In_Court_S_A_F_U)-Dsum("Out_Court_S_A_F_U","RV_Outgoing") From RV_Incomming;


It is working well in access when i run it as a query.



I have Form in which a Label Named LBL1, So i want LBL1 caption to be the result of above query when Form Loads

how can i get it

pls advise.

[Ruegen]

1. Does the form have the query as the record source?

2. Is the query displaying the right information?

If it is displaying a result you can drag in that field on to the main form and it should display on the record.

[Naveen Marapaka]

Hi,

No Form dont have the query as record souce,
I need Coding which system accepts as VBA how can i run and display the result on LBL1 when form loads.

My query is simply and it is working when i directly runs as access query.

regards

[HuubVanOers]

Hi dear, I have 2 tables and I made a query to get the Dsum of a field in 2 tables.

as Select Sum(In_Court_S_A_F_U)-Dsum("Out_Court_S_A_F_U","RV_Outgoing") From RV_Incomming;

It is working well in access when i run it as a query.

I have Form in which a Label Named LBL1, So i want LBL1 caption to be the result of above query when Form Loads

how can i get it

pls advise.

Hi Naveen
on the form onload event (properties of the form, tabpage events)
first use a function in the form, not the select like: rv = dsum(...) etc
then set the result (rv) as lbl1.caption = rv (if jyou want to do it nice use cstr(rv), to make it text


gr, Huub

[Naveen Marapaka]

Hi Gr,

thank you for the suggestion.
i got your point and it worked , thank you again.
DSum("In_Court_S_A_F_U", "RV_Incomming") - DSum("Out_Court_S_A_F_U", "RV_Outgoing")