Expression builder

[elvin_08]

hi all ,

I have a problem on to use expression builder

i have a field of

combo box - "Select Laboratory"
text box - "Number of PC to be borrowed"
and a text box
"Available PC in Selected Laboratory"

i want to sum all 'COMPLAB1' in Number of PC to be borrowed if the Select Laboratory is 'COMPLAB1' and put the total in Available PC in Selected Laboratory

HELP ME GUYS, IM PANIC
THANKS IN ADVANCE

 

[vbaInet]

In the Control Source of your Available PC in Selected Laboratory textbox, oh what a bad naming convention :

=DSum("[Number of [URL="http://www.access-programmers.co.uk/forums/showthread.php?t=215404#"][COLOR=darkgreen]PC[/COLOR][/URL] to be borrowed]", "[[COLOR=Red]Table Name here[/COLOR]]", "[Select Laboratory] = 'COMPLAB1'")

 

[elvin_08]

oh my god thanks for your help you make me happy for your quick response...
a big THANK for you vbaInet have a great day.. god bless

 

[vbaInet]

Happy to help!