I am new to VBA. I am developing a program to input problems and goals on patients. The patient may have multiple problems. Also the problems may have hundreds of variations. So I have used a combobox to add the actual values stored in the problem field. This part is working well. Each problem has a linked table with various goals, also which may change. I have set up a patient file, patient problem file, patient goal file, problem list file and goal list file. I do not want to save simply the file references because both the problem and the goal will likely be edited from the original file.
What I would like to do after adding a problem to the patient problem file, is have the corresponding goals from the goal list appear on the screen all at once (there is usually less than 10 goals per problem). I would like to simply be able to click a yes/no type box in front of each goal to make a choice. Then copy those checked goals to the patient goal list with the corresponding patient number. I can do this with append queries and the like, but it seems like their should be a smoother and more efficient way of doing this via VBA with Access.
Any help would be appreciated. Thanks.
What I would like to do after adding a problem to the patient problem file, is have the corresponding goals from the goal list appear on the screen all at once (there is usually less than 10 goals per problem). I would like to simply be able to click a yes/no type box in front of each goal to make a choice. Then copy those checked goals to the patient goal list with the corresponding patient number. I can do this with append queries and the like, but it seems like their should be a smoother and more efficient way of doing this via VBA with Access.
Any help would be appreciated. Thanks.
