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