Search results

  1. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    UPDATE! It worked!!!! Thank you arnelgp!! I had to change one little bit where you referenced lngPO = Nz(Me![Purchase Order ID], 0) Had to point this to the subform where the Purchase Order ID field is. I'm tickled pink!! Thank you so much!
  2. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    This is awesome! I've been busy today, but will take a look at it tomorrow as soon as I get in. Thank you so much for the suggestion! I'm meeting with the managers next week to show them the database so would be nice to have this little bit of "eye candy" working! I'll check back when I've...
  3. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    Thanks for the input! I haven't had time to work on it today (busy), but will take a look at this approach as soon as I can. I'll let you know how it works out.
  4. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    The database is full of sensitive information (I've imported all our data and am using it to keep track of projects at the moment)....wouldn't know how to clear it all out to send to be honest. I've been mucking around with your suggestion though. So I've created a Totals Query and have it...
  5. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    Thanks for the reply! I'll see how skilled I am at setting this up. Will post a reply if I either figure it out or get more frustrated.
  6. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    First time posting here. Hope I've got this in the right place. My experience with Access is limited, however, with alot of "googling" I can usually get things figured out. I have used the Northwinds template db to create a database here at work that ties together Projects, Opportunities...
Top Bottom