Attendance form help - Access Newbie

[daithiboy]

Evening all,

I'm new to Access so please bear with me. I have an excel userform set up to track CPD points for doctors attending meetings. It works by selecting a meeting type from a combobox and then a list box will populate a list of all doctors registered to that meeting. So I enter the meeting date into a textbox, select the attendees on the list box and then my command button adds the selected names to end of my attendance table with the date.

It works pretty well, but I need to move it to a database structure.

I am wondering how I can replicate the userform system above for access. Here is how I've related the tables and I've put in some dummy data and the query of the attendance table gives me the info I expect. This is encouraging but I don't know how to progress. This is my first time setting up a database, so any advice is much appreciated.

I've done plenty of googling but can't really find much to direct me.

Many thanks in advance.
Dave

 

[alansidman]

Build a parameter query and have your combo boxes be the source of the parameters. If you would like to upload your sample db to a third party like Dropbox or box.net then I will look at more specific instructions

 

[daithiboy]

Build a parameter query and have your combo boxes be the source of the parameters. If you would like to upload your sample db to a third party like Dropbox or box.net then I will look at more specific instructions

Hi Alan,

Thanks for getting back to me. I'm not sure exactly what you mean by a parameter query??

I'm also wondering, with my attached table setup, would I be able to see which meetings a person is enrolled in?? For instance, if John Murphy attends both Sarcoma and Melanoma meetings. Would I be able to show this in a list box i.e. choose "Sarcoma" in a combo box and the listbox populates with John Murphy and anyone else who is enrolled?

I hope that makes sense?

 

[alansidman]

Here is the basics for a parameter. You can make this part of the query filled based upon a combo box in a form.

Use parameters to ask for input when running a query - Microsoft Support

Adding parameters to an Access desktop database query makes it ask for criteria so that it filters the results.

support.microsoft.com

Look here for further instructions on building the parameter based upon a combo box.

 

[daithiboy]

Here is the basics for a parameter. You can make this part of the query filled based upon a combo box in a form.

Use parameters to ask for input when running a query - Microsoft Support

Adding parameters to an Access desktop database query makes it ask for criteria so that it filters the results.

support.microsoft.com

Look here for further instructions on building the parameter based upon a combo box.

Thanks very much Alan. These seem to be very helpful.