Displaying info from fields in 2 different tables on 1 form.

[Steve]

Hey guys,

I'm fairly new to Access so here goes.

I have a form. On this form i want to display a total of
the number of servers found in the "Server Information"
table. However, i also want to display a total of the
number of servers found in the "Web Portal" link table on
the same form.

Can I do this?

I know that i can set the record source to a table or
query in the forms properties, which is how i can do this
for one table/field, but i don't understand/know how to do
this for multiple tables/fields.

Can anyone help me please!!

 

[Gerald Stanley]

You can use the Domain function DSum. For example, if you
set the ControlSource of a textbox to =DSum(1,"Web
Portal"), it should display the number of rows in the Web
Portal table. Similarly, if there is another textbox on
the same form with a ControlSource of =Dsum(1,"Server
Information"), it should display the number of rows in the
Server Information table.

Hope This Helps
Gerald Stanley MCSD