Hi, I am new to this forum and new to Access. I am a doctor and want to make a report (I think) that I can open in report form and "choose" from different list boxes to order medications. I have made the tables and they have "relationships" (not the same definition in medicine). When I open the report, the format looks okay, but I am not able to choose any list boxes.
The list boxes would be: medication orders, a-z then I would choose e.g. a, and need a list box that gives me all the drugs that begin with "a" that I have entered. After I choose e.g. amoxicillin, then it needs to take me to "dosage" where a list of different doses is available....the last box needs to have the option of "orders complete" where it would print what I have chosen or continue orders which would take me back to the first process.
Is this the best way to do it or can someone direct me to a better way? I need to be able to add medications at times.
Any help would be great! Thanks, Robin
The list boxes would be: medication orders, a-z then I would choose e.g. a, and need a list box that gives me all the drugs that begin with "a" that I have entered. After I choose e.g. amoxicillin, then it needs to take me to "dosage" where a list of different doses is available....the last box needs to have the option of "orders complete" where it would print what I have chosen or continue orders which would take me back to the first process.
Is this the best way to do it or can someone direct me to a better way? I need to be able to add medications at times.
Any help would be great! Thanks, Robin
Robin.
