double click events

[shutzy]

i have had a programmer design a diary for me however i do not know how it works and he seems a little reluctant to give up his secrets. the only thing is i want to be able to edit what it does on dbl click events.

ie. if status = 1 then open form a etc.

the whole thing is done with vba and queries and tables. im having a hard time figuring out how things relate and im wondering if someone wouldnt mind taking the time to explain it in depth.

i have uploaded the database parts that are relevant. the form you are needing to look at is frmDiaryMultiView

thank you

 

[Khalid_Afridi]

Lot of update Insert and Select queries. the form itself have lot of IIF conditions on each field. i.e =IIf([Forms]![frmDiaryMultiView]![chTreatment],[Item1],[Client1])
the double click event has missing reference Id to a form
DoCmd.OpenForm "frmNewAppointment", , , "OrderID = " & lngAppmntId & ""

What do you want to know exactly? and why you need it. its a complex application with so many queries.

 

[shutzy]

the application is for a salon(my salon) its an appointment system. as i am learning more about access i am realising that the is more than one way of doing this other than queries. i dont know much about vba so i cant do it that way yet. if you think there is a lot of queries now you should of seen it 3 months ago. i had a query for every list box(lol).

what i want to know is how it works. i know that when i click the date(tomorrow/yesterday etc) it runs queries. but i dont know in what order. also on the double click event for the subform i would like to know how to put in there

if status = 1 then open form a
if status =2 then open form a
if status =3 then message(you cant edit an appointment when it has been paid for)
if status =5 then open form b

just this kind of thing really.