Search results

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...