Error handling an object for multiple errors

[Workaholic]

I have an error handler for a requery sub, my problem is that the sub can have two errors at once. How can you work with multiple errors

ie If Err = 1234 then.........
If Err = 5678 then.........

I've tried searchng but I can't find any multiple error handling

 

[WayneRyan]

Work,

I've never seen a multiple error! Can you post the database?

Remove unneeded items.
Tools --> Database utilities --> Compact/Repair
Then ZIP to a file and attach.

Wayne