Lock Out Tag Out db

[Guest]

I have a Lock Out Tag Out db for doing maintenance at a power plant. This db
puts equipment ID and status on a list so that maintenance can be performed
safely. Some maintenance is repetative, so we build many similar tagouts.
How can I store sample tagouts so that I can develop a standard tagout?

Analogous to a standard customer / product sales mix. Perhaps each customer
would buy the same 12 items to start being a customer and you wanted to speed
data entry.

 

[Arvin Meyer [MVP]]

You can build a table with the values, then use a recordset to retrieve
those values or do a lookup from a combo box to fill in the values.

Have the combo box look up the specific tagout, then populate the form in
the combo's afterupdate event. The combo's column property (which uses a
zero based index) would be used like:

Sub cboTagout_AfterUpdate()
Me.txt1 = Me.cboTagout.Column(2)
Me.txt2 = Me.cboTagout.Column(3)
Me.txt3 = Me.cboTagout.Column(4)
Me.txt4 = Me.cboTagout.Column(5)
End Sub

Adding all the data to the combo's columns is really only feasible if you
have no more than 3 or 4 dozen entries. After that, it may be more efficient
to look up with a recordset.