Hi people,
in my database i have a table called tbl_function and a form called frm_function, what i am trying to do is check availability, so that when a button is clicked it will activite a macro to check if the input of the 'timein' 'timeout' 'location' and 'datein' fields on the form are already present in the tbl_function
so this is my condition:
Forms![frm_Function]![DateIn] And Forms![frm_Function]![Location] And Forms![frm_Function]![TimeIn] And Forms![frm_Function]![TimeOut] = [tbl_Function]![Location] And [tbl_Function]![DateIn] And [tbl_Function]![TimeIn] And [tbl_Function]![TimeOut]
but when i put this in as a command on the frm_function i get an error message saying - "the object dosent contain the automation object 'tbl_function'"
so is there any way around this?
in my database i have a table called tbl_function and a form called frm_function, what i am trying to do is check availability, so that when a button is clicked it will activite a macro to check if the input of the 'timein' 'timeout' 'location' and 'datein' fields on the form are already present in the tbl_function
so this is my condition:
Forms![frm_Function]![DateIn] And Forms![frm_Function]![Location] And Forms![frm_Function]![TimeIn] And Forms![frm_Function]![TimeOut] = [tbl_Function]![Location] And [tbl_Function]![DateIn] And [tbl_Function]![TimeIn] And [tbl_Function]![TimeOut]
but when i put this in as a command on the frm_function i get an error message saying - "the object dosent contain the automation object 'tbl_function'"
so is there any way around this?