2448 runtime error

[stormcloudgathering]

I have a form upon which I have created a button and assigned the "duplicate record" action to it.
When my user attempts to use this command button she gets a 2448 run time error.
When I look at the VBA screen there is a yellow line over the following line of code (code written by my good friend Harvey)

[Forms]![HBOS_Deliverables]![Total_Days] = strDaysLate


I fear my VBA skill stops right there!

Any ideas about how I can resolve this, please?

Please be gentle with me, I can follow simple instructions - just!
many thanks
lynne

 

[essnrv]

Check Isloaded("HBOS_Deliverables&quot before assigning value Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

 

[stormcloudgathering]

thank you for this, but I fear I have no idea where to put "isloaded".
Where would I put this, please?!
thanks
lynne

 

[stormcloudgathering]

could anyone tell me where I need to put the isloaded bit please?
thanks
lynne

 

[essnrv]

Write A Function called IsLoaded in a Module
Function Isloaded(FormName)
Isloaded = (SysCmd(acSysCmdGetObjectState, acForm, FormName) <> 0)
End Function

In Your Form Check for Form

If Isloaded(&quot;HBOS_Deliverables&quot then
[Forms]![HBOS_Deliverables]![Total_Days] = strDaysLate
end if

 

[stormcloudgathering]

oh dear...
Many thanks for your help, but I've yet to do the VBA course. I've no clue where even to start with your instructions...
Thanks again though

lynne

 

[Koaz]

Haha!! Me think i fall in the same situation with u, lynne.
I will follow closing with the post...