adding a filtered list to a form?

[merlin777]

I'm an access newbie so please excuse me if this is a bit of a basic question...



I'm constructing a database to record appointments. I want my users to input their appointments on one half of a form (I can manage that bit) but on the other half I want them to be able to see a list of the appointments they already have booked that day (with any patient) or what the patients already have booked that day (with themselves and any other therapists). The appointment fields they will need to see are:

• start time
• end time
• patient/therapist (depending on if they are viewing their own or the chosen patients' appointments
• type of appointment (physiotherapy etc)
• location

The date won't need to be seen but will dictate which day's appointments are listed.

At it's simplest I could get away with a list of the day's appointments for the patient and date the therapist has typed into the form to start the record.

Ideally I'd like them to be able to choose whether to see a list of the patient's appointments for that day or their own. If there's room I would display both.

Here's the final, 'moon-on-a-stick' bit... it would be great if I could show the appointments in time slots rather than just as a list. From what I can tell that's quite tricky to pull off but i thought I would ask anyway...

At the moment I don't even know what keywords to look up - is this 'embedding a report in a form' or 'inserting a filtered list' and so on.

Anything you could do to steer me in the right direction would be greatly appreciated.

[burrina]

1. Filtered Time Slots:

Between [Forms]![frmSomeForm]![StartDate] And [Forms]![frmSomeForm]![EndDate]

2. Patient: Either use a combo or ask for criteria in query.
3. Also use a combo or criteria in query.
4. Location: Same as above.

This could all be done on the form with combo boxes.

HTH

[June7]

Consider a split form with unbound controls as suggested by burrina to use for filter criteria input. Review http://www.allenbrowne.com/ser-62code.html

Showing all time slots for a day even if there is no appointment(s) for that time is tricky and should be done on a report.

Bing: Access database appointment scheduler
Review:
http://office.microsoft.com/en-us/te...001000405.aspx
http://www.microsoftaccessexpert.com...-Database.aspx

[merlin777]

Showing all time slots for a day even if there is no appointment(s) for that time is tricky and should be done on a report.

is it not OK to have a form longer than the screen and scroll it?

[June7]

Certainly can scroll. However, forms are for data entry and showing a slot for every time period is even more difficult than on report. Making a data entry form look like an appointment book is not easy. I've never built one and expect it likely involves unbound forms and lots of VBA. Did you explore the links?

[merlin777]

Certainly can scroll. However, forms are for data entry and showing a slot for every time period is even more difficult than on report. Making a data entry form look like an appointment book is not easy. I've never built one and expect it likely involves unbound forms and lots of VBA. Did you explore the links?

yes i've had a look at them but my inexperience will prevent me from modifying them or understanding their approach at the moment.

I think the suggestion i've had at the moment is to create a report and put it in a sub form.