Question

Asked on 1999-09-24 at 12:15:53ID: 25033289

Syntax error populating listbox

by: dsa7100

Rating6.0Good

For an application I am helping to develop I have forms that have a listbox at the top of the form containing parent records and then many listboxes on tabs at the bottom of the form that contain the child records.  I create cursors to populate the listboxes for the child
records and set the rowsourcetype = 6 and rowsource = "table1.field1,field2, etc..."  Everytime the user selects a parent record I rebuild the cursors to contain the correct data.  On very rare occasions the program crashes on the line rowsource = "table1.field1,field2, etc ..."  and gives the error "10 - syntax error".  I've checked to make sure the that line is okay and it is.  I have never been able to duplicate this error when I am trying to debug it but the error appears every once in awhile.  Has anyone ever seen this?  Any ideas why this happens?  It concerns me that this error just pops up on rare occasions and I am unable to duplicate it.

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
duplicate error listbox syntax
Participating Experts
3
Solution Grade
C

Replies

 by: dsa7

Posted on 1999-09-24 at 12:17:20ID: 26222277

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: HUGHCB

Posted on 1999-09-24 at 15:28:34ID: 26222278

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: ClareBuxton

Posted on 1999-10-02 at 12:43:52ID: 26222279

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mikeayuso

Posted on 1999-10-04 at 13:24:48ID: 26222280

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?