hi i have a system that is for booking rooms, as i have to split the system for 4 ict rooms, has created the problem. Yet getting rid of these other rooms would not do.

Option Compare Database


Public Function fnbooking()
Forms!frm_roombookingsWICT2.cboDay2.SetFocus
fnbooking = Forms!frm_roombookingsWICT2.cboDay2
End Function
Public Function fnteachers()
Forms!frm_roombookingsWICT2.txtTeachersInitials.Se tFocus
fnteachers = Forms!frm_roombookingsWICT2.txtTeachersInitials
End Function
Public Function fnbooking2()
Forms!frm_roombookingsWICT1.cboDay.SetFocus
fnbooking2 = Forms!frm_roombookingsWICT1.cboDay
End Function

this is the function i am using to define information that is shown in another combo box by the first one setting the paramaters. yet with this it comes up with a problem, when i run this from the wict1 form it highlights a error and needs to be debugs and says Forms!frm_roombookingsWICT2.cboDay2.SetFocus is the problem yet when i run wict2 form with out wict1 there is no problems please help me :(

These functions refer to 2 forms (WICT1 and WICT2). Are both forms open at the time these functions are run? If they are not both open, this will cause an error.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Public Function fnbooking()
Forms!frm_roombookingsWICT2.cboDay2.SetFocus
fnbooking = Forms!frm_roombookingsWICT2.cboDay2
End Function

Public Function fnbooking2()
Forms!frm_roombookingsWICT1.cboDay.SetFocus
fnbooking2 = Forms!frm_roombookingsWICT1.cboDay
End Function

i know it may look the same its the fact that it wasnt the same in my database for some reason it was missing fnbookings2 on the 3rd line of the second line and now works and my system is now finished :D and allows me to book ict rooms effortlessly if you need help on bookin rooms just ask