title: MS-Access: Populate modal form from custom type
body: <p>I am trying to display an error form, populated with text from a custom type object, as a MS-Access version of the fantastic answer on <a href="https://stackoverflow.com/questions/6028288/properly-handling-errors-in-vba-excel">this Excel question</a>. </p>
  
  <p>The problem I run into is that I want to wait for a user response/confirmation on this error form, so it must be (as far as I am aware) a modal form and therefore I cannot just open the form and immediately populate it.</p>
  
  <p>I have tried to find a way of doing in Access what was done in Excel; load the form, populate the form then display the form, but this doesn't seem possible since Access' event order is Open->Load->...</p>
  
  <p>I have also tried looking for a way to open as a normal form, populate and then 'modalise' the form but could not find a way to do this.</p>
  
  <p>Does anyone know of a way to achieve this function? Or is there an alternative to modal forms to pause execution awaiting user input?</p>