i am using Access 97 in a Novell environment.<br><br>i have a table with records (and a primary key called ID). some of those records will require the users to create a work ticket. there are 3 types of ticket the user can create: power, iron, fiber.<br><br>then i have a table called tblTickets. It also contains the ID field, as well as a field called Type and that contains either a 1, 2 or 3. (i have another table called tblTicketType that associates 1 with Power, 2 with Iron and 3 with Fiber.)<br><br>so on a form, i have 3 command buttons, cmdPower, cmdIron and cmdFiber. what i want is for my form frmTickets (based on the table tblTickets) to open and display only the Power records when the cmdPower button is clicked, only the Iron tickets when the cmdIron is pressed and so on. but if there is no existing Power ticket created, i need a blank form displayed so the user can create a new ticket. then i need to somehow make sure the value of Type is 1.<br><br>i don't want to create 3 separate queries. i was hoping to do it all with one. <br><br>any ideas?<br><br>