Search results

Thanks, that did the trick.

When I Maximize a form and then close it every other form opens in Maximzed view. Is there anyway to stop this from happening? I tried the DoCmd.Restore under the resize event (which worked) but then the next form I open is Maximized again. Any Help is much appreciated. Mark

You could use this code under the Command button of the search form. DoCmd.OpenForm "Form to Open", , , "ID =" & Me.ID This will open the new form with a Where clause You can also use "Me" to access variables from the recordset from which the form is based. Check out DoCmd.OpenForm and Me...

I tried the DoCmd.RunCommand acCmdZoom150 statement from the command button and I got a "Command or action 'acCmdZoom150' isn't available now" error. Could this command be in a reference that I haven't enabled? Mark

Thanks for the help, Rich and Fornation. I'll give those a shot. Mark

Hi, I'm trying to set the zoom level for a report print preview using VBA. I already set the Orientation using PrtDevMode. Any suggestions to set zoom level on OnOpen. Thanks Much,