dynamic form that creates boxes based on true\false

[systematic]

Basically I want to hit a button on the switchboard, it looks at a table (where data was previously entered). This table has yes\no check boxes and if all the check boxes are ticked it returns a positive result with a green textbox and if it's false it returns nothing (or a result with a red text box would be ideal)
I can get it to create the form dynamically but that's about it.
here's what I have so far:

The table I want to get data from is called kits, and I did manage to get it to draw a result with Dlookup but that only returned one result.
Basically I'm building a status page of laptops for quick reference on what's available based on data in a table.

[CODE]
Sub NewControls()


Private Sub Command0_Click( )

Const twipsPerInch As Long = 1440

DoCmd.Close acForm, "create new Form test" 'close current form
DoCmd.OpenForm "Stemplate" , acDesign ' open stemplate in design


'create text box
With CreateControl(F ormName:="Stemp late",ControlTy pe:=acTextBox, Section:=acDeta il, Left:=2 * twipsPerInch, Top:=0.02 * twipsPerInch, Height:=1000, Width:=2500)
'set control properties
.Name = "txtTextBox "
.BackColor = RGB(0, 255, 0)
End With



DoCmd.OpenForm "Stemplate" , acNormal
DoCmd.Restore


End Sub

[/CODE}