Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing field (Access 2000)

    I have a very good popup form for searching the customers. After finding a customer, by clickig 2 times on it i get the following error :
    Microsoft Access cant find the field lstCustInfo referred to in your expresion.Bu the field is available on the form . Can you help me ?
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing field (Access 2000)

    That field is not available on the frmCustomers form, it is on the search form.

    What did you want to do, clear the listbox? If so, set the rowsource of the list box to "".

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing field (Access 2000)

    If you want to deselect the row in the list box, change f to Me:

    Me![lstCustInfo].Value = Null

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •