Hello,

I am having to develop a simple access based UI application. I have placed all controls, named them and also wrote code for form load and a button click event. However, when the form loads, the load event is not triggered. It was working earlier. I am not sure what I did but now, none of the events are recognized. No errors are displayed either. can someone help pls? This is urgent. Thanks a ton for your replies.

The following is the code under form load event -

Private Sub Form_Load()
    'Setting fields to empty

    AppList.Value = ""
    AppManager.Value = ""
    BOAReqNum.Value = ""
    InfyReqNum.Value = ""
    BusCritical.Value = False
    CloseDay.Value = ""
    CloseMonth.Value = ""
    CloseYear.Value = ""
    CurrStatus.Value = ""
    ReqType.Value = ""
    IncidentRole.Value = ""
    ReqDesc.Value = ""
    ResolDesc.Value = ""
    RootCauseDesc.Value = ""
    NegProdImpactDesc.Value = ""
    ProdIssue.Value = False
    RespSev.Value = ""
    RestSev.Value = ""
    FinalSev.Value = ""
    Priority.Value = ""
    RCACat.Value = ""
    LOCForEnh.Value = ""
    ProdImplType.Value = ""
    OpenMonth.Value = ""
    OpenDay.Value = ""
    OpenYear.Value = ""
    OpenTime.Value = ""
    TransferMonth.Value = ""
    TransferDay.Value = ""
    TransferYear.Value = ""
    TransferTime.Value = ""
    CloseMonth.Value = ""
    CloseDay.Value = ""
    CloseYear.Value = ""
    CloseTime.Value = ""
    ProdRespTime.Value = ""
    ProdRecTime.Value = ""
    ProdResolutionTime.Value = ""
    EstMonth.Value = ""
    EstDay.Value = ""
    EstYear.Value = ""
    ActMonth.Value = ""
    ActDay.Value = ""
    ActYear.Value = ""
    EstEftHrs.Value = ""
    ActEftHrs.Value = "'"
    PreMonEftHrs.Value = ""
    EstImprovement.Value = ""
    ActImprovement.Value = ""
    PassAccept.Value = False
    NegProdImpact.Value = ""
    AppList.SetFocus
End Sub

Welcome to Wrox!

There is nothing in your code that would make it evident whether it's firing or not. All you're doing is setting textboxes, comboboxes, and checkboxes to empty strings or false.

This is not really necessary because

1) when you designed your tables, your yes/no fields could have been set to FALSE as default initial value there.

2) As for the textboxes and comboboxes, if you don't set them at all, their default values are NULL. You set them to empty strings "" which is not the same thing. Ideally, if you didn't set a textbox to some value, you WANT it to be null.

Therefore, from my limited understanding of what your form does, that whole load procedure is totally unnecessary (see 1) or even problematic (see 2).


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division