Search results

Thanks for your help, I couldnt actually use the not in List event in the end due to the fact that i did not want to limit the entries to the list. I have however, after much frustration, finally got it working. It turned out to be quite simple as suspected and just involved running a few more...

Hi, cheers for your help here. What ive got basically is a combo box which has a list of companies in it. This is on a form called Frm_referrals. The combo box is called OrgansiationSendingReferral and runs off of a table called Tbl_HSOfficeLookup. In the table Tbl_HSOfficeLookup each company...

Right, ive got If (DLookup("Organisation", "Tbl_HSOfficeLookup", "[Organisation] = Forms![Frm_Referrals]!OrgansiationSendingReferral") ) Then DoCmd.OpenQuery "Qry_ReferralCodeUpdate" Else DoCmd.OpenQuery...

Thanks for your quick response! I will investigate and come back if i have any more questions!

Hi, How do you compare a field in your current table to a field in a different table? I have: If [OrganisationSendingReferral] = Tbl_HSOfficeLookup![Organisation] Then..... blah blah blah End If It doesnt like that top line at all though! any suggestions?

Thanks you two, i was beginning to fear as much!

Hi, i am stumped. I have two tables Tbl_Referrals and Tbl_CMSData. Both of these tables have an identifier in called ConflictID. I have created a query which selects the records from both tables where the conflict ID is the same. I have a form running this query. Down one side of the form i...