Recent content by kgoneill

  1. K

    Print multiple records based on query

    Hello, I currently have a report that shows all of the most recent information for a chosen machine. Some of the users have requested a button that will print that same report for all of the machines in a chosen area at once. I've created a query that returns the list of MachineNumbers for...
  2. K

    Combo box recordsource based on IF statement?

    Thanks, I'll try that and let you know how it goes...
  3. K

    Combo box recordsource based on IF statement?

    I tried changing that, but it seems to think that "If" should start a sentence - I don't have it right in front of me to give you the exact error message, sorry! Any other suggestions?
  4. K

    Combo box recordsource based on IF statement?

    Hi, I have a form with three combo boxes: Division, Department and Sublocation. I've managed to get the second two to update based on the previous choices (i.e. Location will only show the choices from the selected Division, Sublocation will only show the choices from the selected Division and...
  5. K

    Copying Subform Recordset to Table

    Sorry for the long delay! I've been dragged over to other projects for the last couple of weeks... Okay, so reading your reply, I'm currently using the second option that you suggested. The user has a combo box to select the base machine, and after that is chosen, that machine's...
  6. K

    Copying Subform Recordset to Table

    Hi, I have a database where machine characteristics are evaluated periodically. When adding a new machine, users can base the machine's characteristics on a similar machine that already exists. Choosing the base machine filters the contents of a subform to reflect that machine's...
Back
Top Bottom