Recent content by Garyn

Actually, I just used the Error Message to cover it and allows me to make a new App by clicking the Classes button. Here's the code I used. Private Sub Classes_List_Click() On Error GoTo Err_Classes_List_Click DoCmd.RunCommand acCmdSaveRecord strWhere = "AID = " & Me.AID...

I decided to just go with the third option an put an Error Trap in there to do nothing. I'd still like to do 1 or 2, but it is beyond my skills, and the 'do nothing' for the Error Trap is fine for now. Thanks again!

Thanks for the help! My relationships are 1 to many on the primary keys (Employee ID for Clients-Apps and App ID for App-Classes). My first form is "Clients" which then can open an "App form" with has "Clients table" in the mainform (to link to specific record) and "App table" in the...

Thanks for the reply! My table relationships are Clients -> Applications (on Employee ID) -> Classes (on App ID). My primary key between Applications and Classes is App ID. First I load the Client form and from there load the App form. If the Client has no Apps, it the form loads and just...

Hello! I am quite new at writing VBA and appreciate any help that I could get. I can usually troubleshoot the basic needs of my database, but this one was a little beyond my current skills.I am using Access 2003 and working with related records between two forms (picture attached). The first...