Combobox should show the values upto the number in the field value of the table

[green369]

Dear friends,

i am having a form PNumberF in which FIDCombo box selected from drop down, TotalP textbox will be populated as per FDetails Table field TotalNoofP value

My requirement is PNumber combobox should display values upto the number TotalP textbox value as per the selected selected FIDCombo box value

can you help me with this please suggest any corrections

i have attached my access file in zip format for your reference


Thanks & Regards

[Welshgasman]

Haven't you already asked this ?
https://www.accessforums.net/showthr...086#post497086

[ArviLaanemets]

Have a table where are listed numbers from 1 to some value big enough.

For combos rowsource, use a query like

SELECT NumberVal FROM tblNumberList WHERE NumberVal <= Me.TotalP