| |

VerySource

 Forgot password?
 Register
Search
View: 21|Reply: 2

Ask about the problem of non-repeating list of combo box values?

[Copy link]

3

Threads

4

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-3-3 15:00:01
| Show all posts |Read mode
I put a combo box in the form, and set a field related to the data value in the generator (the material name of the material library), but the same name in the list box is in the list box, how to let them only One so that users have a clearer choice? Thanks a lot :-)
Reply

Use magic Report

0

Threads

19

Posts

14

Credits

Newbie

Rank: 1

Credits
14

 China

Post time: 2020-5-16 10:45:01
| Show all posts
select dist material name into cursor ltmp from material library

Then bind the field material name in this temporary table ltmp
Reply

Use magic Report

0

Threads

19

Posts

14

Credits

Newbie

Rank: 1

Credits
14

 China

Post time: 2020-5-16 15:30:01
| Show all posts
INIT event of the form

select dist material name into cursor ltmp from material library
THIS.COMBO1.ROWSOURCE = NULL
THIS.COMBO1.ROWSOURCETYPE = 6
THIS.COMBO1.ROWSOURCE = 'ltmp. Material name'
THIS.COMBO1.DISPLAYCOUNT = IIF (RECCOUNT ('ltmp') <= 20, RECCOUNT ('ltmp'), 20)
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list