title: Login Screen in Access with forms, macros and queriesms-
body: <p>I have an embarrassing question regarding Access. I can build relational databases in my sleep but I have always used PHP, mySQL and HTML to build my applications.</p>
  
  <p>I've hated Access with a passion for various reasons ever since I can remember but now I'm stuck using it for a particular project.</p>
  
  <p>I have a number of tables, one of which is <code>customer</code>, which among other things has a <code>username</code> and <code>password</code> field.</p>
  
  <p>When I start the database, I want a login form to appear, which I can do using the <code>AutoExec</code> macro, I've made the form with a username and password field. After that, I get stuck with the logic of querying for the username/password and then showing a new form if correct or an error if not.</p>
  
  <p>Could anyone help me out with making the macro and query work together?</p>
  
  <p>Clarification: I am trying to do this without coding whole Visual Basic macros, if at all possible, I want to be able to do it using the macro builder thingumy.</p>
  
  <p>Thanks</p>