Form Filtering.

[glamster7]

Hi Folks,

I have a form frm.viewbookings which shows in the header the labels Stylist1 through to Stylist 7 with the stylist names underneath them. In total for the set of data I have there are 14stylists. Ok behind all this we have 2 tables tmp_bookingsGrid & tmp_clientGrid.

Also in order to populate the form we run several queries in order to populate these tables with the required data & show the following in the detail section of the form Client_Id_No, Booking_Client_Name, Booking_Client _Address, Booking_Contact_No & Booking_Appoint_Type.

In the form footer we have our command buttons.

The form currently shows all the bookings for a particular date. what I would like to be able to do is show only the bookings for Stylists 1 to 7 on the form & then click on a button & show the next 7 stylists with the bookings for these 7 stylists.

I'm not quite sure how to go about this. If ya need anymore details (code etc)let me know. also instead of nothing showing if there is no appointments at a certain time I would like a blank row to appear in that slot/slots that is/are missing

[MMcCarthy]

Have a look at the following tutorial.

Example Filtering on a Form

[puppydogbuddy]

You should also take a look at this 3rd party tool which costs less than $20:

It is a form builder that enables you to select the features (including filtering) you want on the form and will build the form for you.

http://www.aadconsulting.com/smtfrmplus.html

[glamster7]

Cheers for your help. Now have the form filtering nicely to show the records I want. Any idea how I would put in a blank row for the appointment times that have no bookings.

Eg On the filtered form showing the 1st 7 stylists I have appointments at 1.30pm,2.00pm,3.00pm,3.30pm,4.00pm &4.30pm. I need to put in a blank row for 2.30pm.

Any ideas or articles/tutorials you can point me to would be great

[MMcCarthy]

Cheers for your help. Now have the form filtering nicely to show the records I want. Any idea how I would put in a blank row for the appointment times that have no bookings.

Eg On the filtered form showing the 1st 7 stylists I have appointments at 1.30pm,2.00pm,3.00pm,3.30pm,4.00pm &4.30pm. I need to put in a blank row for 2.30pm.

Any ideas or articles/tutorials you can point me to would be great

You will need to create a table of all the available times. Then left join that table to the table/query behind the subform so that all times show on the subform.

[glamster7]

Thanks I'll try that