ACCESS FEED: RE: [MS_AccessPros] error 13 type mismatch

Sabtu, 01 Oktober 2011

RE: [MS_AccessPros] error 13 type mismatch

Hi rkulez

(Please sign off your messages with your name – it's much friendlier that
way :-)

What John meant was not to add another 'On Error line, but to modify the
existing line and insert an apostrophe at the beginning:

'On Error GoTo Err_Handler

Also, you cannot run an event procedure from the VB window. You must open
the form and trigger the event by updating the record on the form.

Best wishes,
Graham

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rkulez
> Sent: Sunday, 2 October 2011 05:48
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] error 13 type mismatch
>
>
> John, I am not good with vb, must I write the code like?:
>
> Private Sub Form_AfterUpdate()
> 'On Error
> On Error GoTo Err_Handler
> 'Purpose: Requery the combo that may have called this in its DblClick
> Dim cbo As ComboBox
> Dim iErrCount As Integer
> Const strcCallingForm = "frm_CaseRecord"
> .......
> .........
> endsub
>
> I wrote this and tried to run it in vb window, but a form named "macros"
opens. In this case I tried to save and open my pop up form but again I get
the type mismatch error. I think I need more explanation.Thanks again.