Search results

I'm getting this error: http://i43.tinypic.com/t6oyz5.png It is called Combo14 Thanks!

Hi, Is the dlookup to get the price from the tblAppointmentTypes? :) Private Sub Combo14_AfterUpdate() Me.CPH = DLookup("[CPH]", "tblAppointmentTypes", "[AppointmentTypeID]=" & Me.Combo14) End Sub I've tried the above in the afterupdate but it doesn't work :confused: I think it may be wrong

Hi, thank you that makes much more sense now :) So for the subform, I am using the following fields: AppointmentBookingID, BookingID, AppointmentTypeID, SessionLength, CPH So I need to make AppointmentTypeID a combo box? And then copy and paste the code you provided in the recordsource?

Ok. So what fields would I bring into the sub-form? Currently, the main form has: BookingID, ClientID, StaffID, StartTime, EndTime, Date The subform has: AppointmentBookingID, BookingID, AppointmentTypeID, SessionLength, CPH, AppointmentType Now that I'm getting CPH from the...

Ooh, I'm sorry :o Can I call the field the same thing? CPH? I have reattached the database. Is this right now?

Do you mean in the tblAppointmentBookings form? I quite don't understand :/ Everything that you've said makes sense, but urghh :confused: :confused:

CPH is cost per hour. SessionLength is the number of hours. If I hold these fields again, then doesn't the database become un-normalized?

Hello (Really sorry about this, but I'm a super noob :() I have attached a shell database for you. It contains the tables that I want to use. What I want to do is make a booking form with a subform on it. I want the main booking form to have the following fields: BookingID ClientID StaffID...

SELECT [tblAppointmentBookings].[AppointmentBookingID], [tblAppointmentTypes].[AppointmentType], [tblAppointmentTypes].[CPH], [tblAppointmentBookings].[BookingID], [tblAppointmentBookings].[AppointmentTypeID], [tblAppointmentBookings].[SessionLength] FROM tblAppointmentTypes INNER JOIN...

Hi, How do you find out the recordsource of the whole subform? Clueless here lol :confused: Actually, I think it's this: SELECT [tblAppointmentBookings].[AppointmentBookingID], [tblAppointmentBookings].[BookingID], [tblAppointmentBookings].[AppointmentTypeID]...

Hi, thank you for replying. I've used a dlookup in the afterupdate thing. Here is the code: Private Sub Combo10_AfterUpdate() Me.CPH = DLookup("[CPH]", "tblAppointmentTypes", "[AppointmentTypeID]=" & Me.Combo10) End Sub

Hi, I am using a combo box to select an appointmenttype. The appointment types are coming from another table. I am using a dlookup to also get the cost per hour from the same table. Trouble is that in my subform, whenever I actually make a booking and select an appointment type, new records...

Really could do with some assistance guys :( Never thought forms were soo much hassle :(

Hi, thank you for replying :] On the subform the appointment type is a combo box which is getting the list of items from the tblAppointmentTypes. I have used a dlookup afterupdate on this combobox too, to get the cost per hour for each type. e.g. Select divorce from the drop down, and then the...

Anyone? Feel really upset and frustrated right now:(

Hello, I have a booking form with the following fields: BookingID ClientID StaffID StartTime EndTime Date TotalCost In this form I have a sub-form with the following fields AppointmentBookingID BookingID AppointmentType CPH SessionLength The problem I am having is that when I want to make a...

It works!!!!!!!!!!!!!!!!!!! :D Thank you sooo much!!!! I don't know how I can ever repay you! I have another problem though and I don't know what's causing it - I'm sure it's unrelated to what we've just done. When I select the appointment type a number goes into the AppointmentType field in...

This is the record source for the combo box: SELECT [tblAppointmentTypes].[AppointmentTypeID], [tblAppointmentTypes].[AppointmentType] FROM tblAppointmentTypes ORDER BY [AppointmentType]; The bound column is 1. The message box is showing the AppointmentTypeID when I select an appointment type...

AppointmentTypeID is an autonumber, that just goes 1, 2,3 etc/ AppointmentType is the name of the types of appointments. E.g. Property law, litigation CPH - Is the cost per hour for the appointments.

Lol, :s is an emotion lol - means confused :p Nothing is returning S. Maybe I should have been more clear :(