Automatic Activation of buttons

Hi there I am a new user that would appreciate some help with a project I am working on. My project extracts information from a large database and the problem I have is some of my procedures are too large for one button. I have therefore split them into 2 procedures. Is there anyway that at the end of the first procedure I can tell it to activate the 2nd button.

yeah. If you're looking at a problem like this, however, it is usually possible to remove excess coding by doing some basic object orientation. for example, if you're regularly calling SQL statements, create a function that returns a recordset. Pass in the SQL statement and the connection variable (byref), and capture your function value in a recordset. The maximum length for a function is actually quite long, and breaching that maximum usually designates that better programming practices could be used, often to better program efficiency.

Thanks for your quick reply Fisherman, your right the code I have is not very efficient but I cannot work out how to fix it. I know it will probably be something simple for the guru's to figger out. If you don't mind in the next hour or so I will attempt to post it for you to have a look at.

ok. but it's about 11 pm here, so I'll be in bed soon. I can look tomorrow as soon as I can.