Search results

This is essentially what I did. In the "On Change" Event Procedure for the preceeding combo box, I put in a dlookup function that looked like this: Private Sub Combo1_Change() Text1 = Dlookup("[Field]", "Query") End Sub So this controls the input into the textbox, while I can still have...

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...

The Union Query is exactly what I needed. Thank you. I was able I followed the instructions from here and got exactly what I needed.

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...

Sorry I did not respond. But i decided to go a different route with what I was looking for. Thanks for the help though.

This is what I would need. I figured it would need a sub query. I just haven't figured out what the code would be for it. Could you help with this?

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...