Katanski

Hello,I need to compare two numbers from separate parts (different tables) of the DB. If the numbers are not equal, I need to send a Message box with a button in it to create new record in the one of the tables.Here is the code I has so far...but it needs some work.Private Sub Command152_Click() On Error GoTo Command152_Click_Err If State = "AZ" ThenDoCmd.OpenForm "AZ Fees & Costs" 'open FormDoCmd.RunMacro "Find_on_click_TS2" 'search for a_ TS#\(ID#) and bring up the infoElseIf "Form.AZ Fees & Costs.TS" <> "Macroload.Find_on_click_TS2" Then MsgBox "No Fees & Costs Exist for this TS #"(+ button that will create new record in Form.CA Fees & Costs.TS")ElseIf State = "CA" ThenDoCmd.OpenForm "CA Fees & Costs" 'open FormDoCmd.RunMacro "Find_on_click_TS2" 'search for a_ TS#\(ID#) and bring up the infoElseIf "Form.CA Fees & Costs.TS" <> "Macroload.Find_on_click_TS2" Then MsgBox "No Fees & Costs Exist for this TS # (+ button that will create new record in Form.CA Fees & Costs.TS")ElseMsgBox "State Unknown"End IfCommand152_Click_Exit: Exit SubCommand152_Click_Err: MsgBox Error$ Resume Command152_Click_ExitEnd SubThank you in advance,David92595

I need to find a way to create a one click button that will select the current record on an access 2007 form and mail merge it with a predefined word 2007 document. we have thousands of records so making sure we get the right one to merge is very important.From looking around online, I can tell you that I cannot use bookmarks or anything of that sort. It has to be mail merge-able due to the fact that that is how all of our word doc's are already set up. I can't copy it to a word table or excel sheet because we constantly have people in our DB adding to it.Any help would be greatly appreciated! Thank you in advance,David92595