hi,
i used the Access to design the form.I have a combo box which have 3 item.Whenever item 1 is selected, then a query will be made to the item 1 table to check the sequence number and put the next number of the sequence into the text field in the form to be displayed. when user click next, the data will be inserted to a table, and increment the item 1 table, else the sequence no if item 1 table will remain unchanged.
what is the best way to do the above function? using expression, macro or code builder? I tried using the code builder, but wasnt sure how to query the item 1 table and get it to display to the form. does anyone have any examples?
thank you
i used the Access to design the form.I have a combo box which have 3 item.Whenever item 1 is selected, then a query will be made to the item 1 table to check the sequence number and put the next number of the sequence into the text field in the form to be displayed. when user click next, the data will be inserted to a table, and increment the item 1 table, else the sequence no if item 1 table will remain unchanged.
what is the best way to do the above function? using expression, macro or code builder? I tried using the code builder, but wasnt sure how to query the item 1 table and get it to display to the form. does anyone have any examples?
thank you
