Refresh every record

[swee]

Hi all,

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.

Thanks for any input!

-Swee

 

[Rich]

Place the code in the Form Current Event and just call it in the AfterUpdate event of your checkbox by putting Form_Current in its event proc.

 

[swee]

Thanks dude. Got it working now. XD