Re: another multi-select combo box mess....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Here is the error message:

Compile error:
Method or datamember not found

cheers & thanx


Iona wrote:
Ok, thanks Keith, I have remedied this (via some database corruption!
argh), however
I find that the requery command is not working, the listbox is holding
onto the selected values no matter what record is on the form.

I have tried

Me.lbContactTypes.Requery
Which it will accept,

however, if I use

Me.tbContactTypes.Requery
It gives me an error message.

Likewise It does not display what records have been selected after you
leave the record and then return to it.

sorry about the headache of this, I just really feel that the
continuous form solution won't work for my client.

any ideas would be appreciated.

regards,
Iona


Keith Wilby wrote:
"Iona" <hmcgregor@xxxxxxxxxxxxxxxx> wrote in message
news:1153438840.950158.184030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Ok ContactID is null



There's your problem, you need to find out why it's null. If "Me.ContactID"
is a text box on your form then it needs to contain a value in order for
your code to work. If null is an acceptable state then you need to handle
the null condition in your code, perhaps something like:

If IsNull(Me.ContactID) Then
rs.FindFirst "[ContactType] = " & lngCondition
Else
rs.FindFirst "[ContactID] = " & Me.ContactID & " AND " & "[ContactType]
= " & lngCondition
End If

Keith.

.

Relevant Pages

  • Re: faulted zpool , do not resilver
    ... The web page mentioned in the error message contains further info, ... (argh, I see it's behind a login now, that's a recent ... One way the meta data corruption can occur is the hard drive lies to ZFS ... when it issues a cache flush. ...
    (freebsd-stable)
  • Error message, "vt: argh, driver_data = NULL!"
    ... I've got a little annoying problem on my system. ... I shut down, I get an error message "vt: argh, ... and I've got to press the power switch. ...
    (comp.os.linux.misc)
  • RE: Excel Worksheet ListBox
    ... My ListBox that I am using is ActiveX type in Excel 2003. ... I am not getting any error message, the list though fully visible does not ... What do you mean by 'does not allow any selection to be made'? ...
    (microsoft.public.excel.programming)
  • Re: ASP.NET - Visual Studo
    ... For the second question, make sure you post the error message you ... In addition I dragged DataGrig, ... My second problem is with the ListBox. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Error 2115 - but not before update ?
    ... The error message actually says ... ... Allen Browne - Microsoft MVP. ... Update event of a listbox): ... I am selecting from a listbox which is not linked to the ...
    (microsoft.public.access.formscoding)