Appointment form

[Richhol65]

Hi

I am working on a database for a friend of mine who has a hairdressing salon and I have created an appointment form which basically has boxes for each time slot for each of the 4 stylists that work in the shop.

I have built in functionality so that when I click on a blank appointment slot the form to enter appointments for that stylist opens with the date, day and time already populated. I can then enter details into this form and this adds data to an appointment table, which holds things like date, day, time, customer, stylist, service etc.

I would like to populate my Appointment form with this Appointment Table data and then when I click on a populated appointment slot the same form would open but with all the current data in there so I could edit it, I would then want the Appointment form to reflect the changes and also reflect any new appointments.

Is this possible as I seem to be struggling populating the form - definitely hitting a brick wall

Thanks in advance

Rich

 

[DavidAtWork]

If you display the PK for the appointment you'd like to edit, you could use the DblClick event of the PK field as criteria to open an editing version of the form
DoCmd.OpenForm "frmApptEdit", acNormal, , "[Appt_PK] = " & Me.Appt_ID

After you've finished editing, this editing version closes and you refresh/requery the main form to see the changes.

David

 

[Richhol65]

Hi David

Thanks for that, is there no way of using the same form for adding and editing the data

Thanks

Rich

 

[Richhol65]

Ok I should be able to sort the form

How do I now populate the form from a table or query

I have a textbox at the top that the person using it can select a date

Then each Stylist has a list of textboxes under their name which correspond to times so for stylist one for 8.00am the text box is called txt10800 (ie stylist 1 at 0800)

The Appointment table has an ID Field this is made up as follows:

ddmmyytttts

dd = date (eg 04)
mm = month (eg 09)
yy = year (eg 13)
tttt = time (eg 1100)
s = stylist (eg 1)

So I can link the date to the first 6 characters and the text box to the time and stylist eg Stylist 1 at 11.00am is txt11000 but i need the field that concatenates Customer name and service in the text box and i need it to populate the whole form from either the table or a query

How is the best way to do this

Thanks

Rich