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
Post a Comment