Hi
not sure if i've posted this in the correct forum but..
i have two forms 1. appointment book 2. Receipts
the two are linked via a common field named "day id" which is a date field. They also have a common number field named "DATE ITEM" which is a number.
I am trying to design a button with a macro attached that for a given day, will filter the receipts form to show only the receipts for that given day. S, 10 people may have paid on 10 November, so if i click the macro on the appointment book record for 10 november, i would like to see those only records in the RECEIPTS form.
I have tried doing this via instructions from online and a text book but have been unsuccessful I have used in the macro, amongst other things, open the Receipts form, in the where argument [date item]=[forms]![appointment book]![date item] but it doesn't work
Any suggestions would be most welcome.
Damen