Recent content by Shredsec.com

That works perfectly. Thanks.

I'm getting this error message: The Expression On Open you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure having the same name

This is the code I'm attempting to use to to filter records by postcode. The idea is that a form only displays records from my table with postcode CB1 or CB2. Can't seem to get it to work. Private Sub Form_Open() Me.Filter = "[Postcode split]" = CB1 Or CB2 Me.FilterOn = True End Sub

Many thanks Adam. Works perfectly.

How do I display a record in my main form by clicking on it in my subform? The data is being pulled from the same table. Tried a GoToRecord macro without success and can't find the answer anywhere.

I'm using this code on a button to find random records in my database but it doesn't find random records - it goes through the same sequence of records. Private Sub Random_record_Click() DoCmd.GoToRecord , , acGoTo, Int(Rnd() * Me.RecordsetClone.RecordCount) + 1 End Sub