ms access - Autonumber combo box field up to value from record? -


i have table sets attributes part assemblies, each assembly gets number of parts. have form new table parts each assembly entered. have combo box fill number of part numbers, control input user has. if assembly has entry "#parts" in record in "tblassembly" combo box "cbopartnumber" in form "parts" fill 1:#parts each entry.

in order attribute number of constant values combo box, first set combo box's row source type property value list. (the default table/query).

now can enter list of values in row source property "1;2;3;4;5". if list variable, can in loop this:

private sub setpartnumbers(byval n long)     dim long     dim s string      s = "1"     = 2 n         s = s & ";" &     next     me!combo1.rowsource = s end sub 

Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -