General information
Category:
Forms & Form designer
You were right on the money - that was indeed my problem. Thanks for your suggestion - it works perfectly!
>If I'm right that's the problem. You use that cursor as a rowsource and probably "makelists" method is trying to do a reselect into same cursor in interactivechange. It cannot because they're in use by combos. Well I think what I say is not clear. OK here is whatto do. Since your combos rely on SQL cursors to show their content, instead of preparing SQL then setting their RowSourcetype as fields, let combos have RowSourceType = SQL and their Rowsource = "select ... into cursor myCursor". Of course cursorname would be different for each combo. Then all you need is to call a requery when SQL content should change :
>
>RowSourcetype = SQL && (I think it was 3)
>RowSource = "select PatName,PIDCode "+;
> "from Patient_ "+;
> "where PIDCode = thisform.pgf.page1.TxtPIDCode.value "+;
> "into cursor myPIDCode"You could put this in init of combo. Leave combo properties for Rowsource* as (None) in designer. Their "requery" could be called in gotfocus of combo if needed :
>this.requery(). If you do this right you would probably need no interactivechange code too (honestly I couldn't understand the purpose there).
>
>Cetin
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only