Search results

  1. M

    How to make a text box to perform as a combo/list box

    I want to have a text box that auto-populates with a value its pulling from a query. I could do this with a combo box and have the record source using the dlookup function. However I do not want the user to have to select this value from the combo box. However I still need the value to be saved...
  2. M

    Pulling two queries back into one

    I have a parent table that contains a list of all of the machines my company owns (Table 1). There is another table that contains all of our maintainence records(Table 2). From the maintainence records table I then create a query (Query 1) that predicts the next maintainence date based off of...
  3. M

    Finding Previous Maintenance Date from a former Record

    My company is keeping track of the maintenance on five of our machines. I have a form to input the machine the maintenance was performed on, the date it was performed, and the severity of the maintenance, and job # as the primary id. I then have a query that shows the maintenance record for just...
Top Bottom