Unanswered: Auto Populate with Query 'After Update'
I could use some help...
I am creating a database for the equipment that my company uses. We area warehousing company with several buildings and hundreds of forklifts. I have a form that equipment operators are supposed to fill out at the end of the day. I created the below query to pull up the most recent information for that unit.
I want to take the information from the following fields and auto populated the same fields in the Status Form after the [Equipment ID] is selected from a drop down menu: [EmployeeID], [Building ID], [Status HourReading], [Maintenance Required], [Maintenance Comments]
If you can help me to solve this problem, I would be extremely thankful.
Ok. Usingf a combo box you can use hidden columns to populate the fileds on your form.
First you need to create a select query to return [EmployeeID], [Building ID], [Status HourReading], [Maintenance Required], [Maintenance Comments], and any other fields you would like returned in the combo box.
You then use the select query as the row source of the combo box, by copying the SQL or tying the combo box straight to your query.
NExt tell the combo box how many columns it has in total. Using the above example it would be 5.
Using the above example if we wanted to search the combo by employee ID, we would set the widths as follows:
This would make column 0 visible and all other columns hidden.
Finally we need a little bit of code to help us out. In the after update event of the combo box we would write code like:
We would repeat this for each column we wanted to pull data from.
Change your query joins until the query shows exactly what you want. In other words show all items of equipment and if there are matches show them. This is a right join(I Think I get them mixed up too)