Getting specific results

[CaptainHut]

Hi! I hope someone can help me with my first ever Access project.

I am a volunteer with a voluntary aid charity and I'm currently designing an access database which will be used as a radio communications logging program.

It's quite simple: the radio controller will receive calls in to the control room and has to log each call as it happens. I've already designed a form which acts as the main interface. The user hits return which opens a the "new call" form where they input the various pieces of data including callsign from (lookup from another table), callsign to (lookup from another table), nature of call (lookup from another table) and a freetext field for the main body of information.

I'd like some advice on how to create a query which will allow me to produce a report which shows specific calls from a specific callsign. The system already has a report which shows all call data from all callsigns, but I'd like to have the same report but produced to show only calls from specific user(s).

Ideally this would be generated from another page where I could pick the users I'd like to show from a drop down box or similar.

Can anyone advise me how to create this query/form/report?

Many thanks.

 

[pbaldy]

Would this work for you?

http://www.baldyweb.com/multiselect.htm

 

[CaptainHut]

Perhaps, it certainly sounds like it! I'll have to give it a go and I'll let you know. Many thanks for your prompt reply.

If I've got any issues (which is almost guaranteed!) I'll ask here. Thanks.

 

[pbaldy]

No problem, and certainly post back if you get stuck.