I have a purchase order form that has a checkbox to determine if it has been approved. If it has been approved, btnApprove and btnReject are hidden and if not, they are shown. However, subsequent unapproved records after the first approved record do not show out the two buttons as they are not 'refreshed'. How do I write the code for it to display the btns based on the individual records?
I have attached a small db for easier understanding of my prob.
Note: FrmLookupRecords is the form I'm talking about.Record 1 has been approved but not record 2.