Recent content by lcp298

Ah, thanks, I'll try that! Do the arguments take the same format as the where condition?

Yes, it is the original form the record was entered onto.

I have an OpenForm on the Click event of a button on a report (I've tried it on a form as well), but the form is not acting on the WHERE clause. Private Sub btnOpenBooking_Click() On Error GoTo Err_btnOpenBooking_Click Dim strDocName As String Dim strCriteria As String strDocName = "Make an...

Just realised I didn't mention this was in Access 2007. Not sure if that makes a difference.

Thank you. Yes, you are right about the reference, when I use the expression builder it shortens it to just [SCHOOLID] etc. I tried your suggestion of: =DCount("*","KitloanCountQry","[SchoolID] = " & [Forms]![MakeaKitloanBooking]![MembershipSubform].[Form]![SCHOOLID] & " And [DateOut] > #" &...

The control with the DCount on it is on the subform (membership subform), the same form as the DateJoined, DateRenewal and SCHOOLID. I did try it without the full forms reference but that's one area I got a bit lost. The dates throughout the DB are UK format, but I s'pose just changing your...

I have created a booking system for a set of resources for schools. Most schools have a membership which entitles them to 2 free sets. I have a booking form with a membership subform (membership table), and a booking details subform (kitloan table). Once a school is selected on the main form...