Counts?

[rebel]

Hi,

Wondering if you could help.

I'm trying to create a booking form for my company where we will have a 3 companies coming to one of our seminars.

I have been asked to create this form and when the user fills in their name, and their company (specified in a bombo box) you then click a button which records the company specified and takes you back to the for the next user.

Now what I want is to display the data on another form showing how many people in total have used the form and will be coming and how many from each company.

I know I have to do some kind of (COUNT?) statements in my onclick() button in my form, but i'm not sure how to keep this all in memory?

Anyone help as i'm VERY new to VBA?

Thanks

Rebel

[salvelinus]

You could do an SQL Count - "SELECT COUNT(fldAttending) FROM tblYadaYada WHERE fldCompany = '" & strCompanyName & "'", looping through the company names, or use a recordset and get the .RecordCount property value.