Re: Switchboard problem

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

Frequently in VB and VBA the line hilited is actually the line following the
problem, which would make the culprit here:

Me.RecordsetClone.FindFirst "[CustomerID] = '" & Me![cboCustomerName] & "'"

I leave most of my combo box coding up to Access, but I wonder if you
changed

& Me![cboCustomerName] & "'"

to

& Me![cboCustomerName.Value] & "'"

if it would help.

Have a Happy Holiday!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200612/1

.

Relevant Pages

  • Re: Unable to select a value from combo box
    ... form is pretty sure to have been the culprit! ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000/2003 ...
    (microsoft.public.access.forms)
  • Re: Delete a Button
    ... You'll have to go into the VBA editor,find the code for the button and then ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000 ...
    (microsoft.public.access.forms)
  • Re: VB In Access
    ... deals with the VBA aspects. ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000 ...
    (comp.databases.ms-access)
  • Re: Change Printer
    ... If all you have is an MDE file, there's nothing you can do in VBA, you have ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000 ...
    (comp.databases.ms-access)
  • Re: Programatically Populate a Field?
    ... "Does VBA know to look into the RecordSet of a form for stuff like this?" ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000 ...
    (microsoft.public.access.forms)