I am AccessVBA beginners, encountered some problems at the moment, hope can get everybody's help, don't appreciate,
Question 1:
FT has built a table in Access, in the form of new combo box Combo21, new text box Text17, new Command1 button,
Want by VBA to realize the function is: in the combo box Combo21 choice model (that is, the Item in table FT), and then through the model to obtain the corresponding table in the FT the values in the "Cut", as well as the corresponding table in the FT "Roll" of values, then the value of the text box Text17 is equal to the table "Cut the value multiplied by" Roll "in the" the value in the
Example: select the model 0001-0029, and then click the button Command1, shown in the text box Text17 value=85.13 * 59.55=5069.4915
What is the complete VBA code?
Table FT
Model corresponding Combo21, the lowest price the corresponding Text17
Question 2: the above models is obtained by the drop-down list to choose from, but a great trouble to model a lot of words to choose, whether can be input part Numbers, and then narrowed to choose,
Example: models have 0001-0029, 0001-0038000-1-0045. If the entry will automatically after 0001-00 the reality of the three models, other models do not show, then you can choose the right one, how to implement?
CodePudding user response:
Can automatic filtering,