Hey. Don't know what happened guys but basically I changed a few things on the form and it seems to have broken. Right now what SHOULD happen is when someone chooses a host it should then go do a DCount of how many other people in the table have the same host.

At this point if I try to put this in Form_Current so it does it right away it gives me a debug message. It was working fine before. Can anyone help? I've attached the database

When you choose a host name it doesnt seem to update the counts of how many people its currently hosting.

Private Sub Form_Current()
HostCount = DCount("[Host]", "[Visiting Students]", "[Host] = " & [Host])
Sending = DCount("[School]", "[Visiting Students]", "[School] = " & [School])
End Sub

As you see it should just count out the host where the host is equal to the host on the form.

Sending is another count for checking how many students are being sent by a specific school although I might delete that later on....

Anyhow HostCount is the name of the textbox which is to be updated...Hope the extra information helps


Edited by: alikhan on Tue Feb 1 9:54:13 EST 2005.

Try this...

HostCount = DCount("[Host]", "[Visiting Students]", "[Host] = ' " & [Host] & " ' ")
Sending = DCount("[School]", "[Visiting Students]", "[School] = ' " & [School] & " ' ")