VBA code to check data in form

[paultje_bos]

All, I have another challenge. I have a form in which people have to enter content of a container. They can highlight the container as WASTE, but then they have to enter waste in the content as well and put in the remarks field WASTE. What I need is a code that checks if there is one or more rows with the remark WASTE if WASTE is selected. If not, it should give you a message with something like "You select the container as WASTE, but no waste is inside the container. Please put Waste in remarks for the applicable lines".

I hope I make sense to you, of not please let me know.

 

[mole999]

maybe conditional format for the range

format only cells with > specific text > containing > waste

and give it a colour

it might be extended to a row or other uses

 

[Micron]

why not set the other applicable fields to 'waste' if the key field is designated as waste, or all applicable fields if even one has been designated as waste? However, if it is possible that additional comments have been entered when this check is run, those comments could be arbitrarily altered to 'waste' during such an update. You'd have to code to either prepend or append the word to the existing comment. Assuming no issues updating the record, something like

If ctl1 = "waste" OR ctl2 = "waste" OR ctl3 = "waste" Then
  With Me
    .ctl1 = "waste"
    .ctl2 = "waste"
    .ctl3 = "waste" 
    .Requery  
  End With
End If

To prepend to a particular field (ctl2), Dim a variable, assign the control value to it then have
.ctl2 = "Waste: " & strVariable

 

[mole999]

Ignore my response, thought I was in the excel section

 

[xenou]

It does seem a little redundant to make people enter "waste" three times (?). Not very efficient data entry.

 

[paultje_bos]

The fact is that inside the container there can be more content than waste, but because we need to have at least one waste item (due to other linked programs) I want to have a check. But I used the idea from Mole999, it is not exactly what I was looking for, but I think it will do the job. Thanks all for the input!