Search results

Right, I've reverted back to this: Private Sub Combo10_AfterUpdate() Me.CPH = DLookup("[CPH]", "tblAppointmentTypes", "[AppointmentType]='" & Me.Combo10 & "'") End Sub In post 16, what do you mean by S?

I've tried this: Private Sub Combo10_AfterUpdate() MsgBox Me.Combo10 Me.CPH = DLookup("[AppointmentTypeID]", "tblAppointmentTypes", "[AppointmentType]='" & Me.Combo10 & "'") End Sub It's still showing the AppointmentTypeID in the box and the price isn't coming up. :(

It comes up with the appointment type id :S In the tblAppointmentTypes I have three fields: AppointmentTypeID AppointmentType CPH I'm guessing I've done something wrong lol :/

I'm getting no errors now, but the actual cost isn't coming up :( Help please!

Hi, I've done that but I'm getting another runtime error " Datatype mismatch" Private Sub Combo10_AfterUpdate() Me.CPH = DLookup("[CPH]", "tblAppointmentTypes", "[AppointmentType]=" & Me.Combo10) End Sub Thanks!

I didn't know we had to build an event procedure lol - such a noob I am :p I've never made an event in Access before :s I'm assuming you mean the name of the boxes on the form for the control names? I've done this, but I keep getting a runtime error :S Private Sub Combo10_AfterUpdate()...

Is there anyway I can attach my database, so you can help me as I'm really clueless lol :( I keep getting an error. Microsoft Access cannot find the object 'me'. Where do I put the code? Maybe I've put it in the wrong place? I've placed it in the After update box, for the AppointmentType combo...

What is "me." ? Please, and thank you. I really want to get this done so that I can rest lol :p

Hi, thank you for replying! Do I do this dlookup after update on the appointment type field or on the actual cost field? Excuse my dumbness but what is me. ? Really confused :S Thanks so much!

Hello, my name is Lakhvir. I am currently finishing off my A2's and am hoping to get into my first choice uni for 2012 start. I joined in order to get some help with my coursework as I'm completely stuck and I feel really dumb :( I can't wait to talk to you all! :D

Hello guys, I'm new :p I'm currently doing some coursework at school and have come across a problem. My system is basically an appointment booking system for a family law firm. I have the main booking form with the following fields: BookingID, ClientID, StartTime, EndTime, Date, TotalCost In...