Ok I have found the solution Thanks to Bob Olston from allexperts.com.
Bob replied with the following;
As I told you previously, you can refer to a control on a form that is the top level form via this syntax
Forms!>formname>!<controlname>
So if NewWarrantExpiry is a control in the Vehicle form, you can update it via
Forms!Vehicleform!newwarrantexpiry = me.newwarrantdate
Some free Access training is listed here:
http://webpages.charter.net/bobalsto...line_Tutorials
and good bebinner books
http://databases.about.com/od/tutori...ccessbooks.htm
Also Google searches that begin with Microsoft Access xxxxxxxxxxx
or
Microsoft Access vba xxxxxxxxx
Can often get you more immediate help.
HTH
Bob
--------------------------------------------
My Attempt
From this I done the following to update the [VehicleTable].
I opened the [VehicleForm] , then switched to design view.
I Double clicked the [update] button which brings up the ButtonProperties.
under the [events] tab I created a new [Event Proceedure] for the button.
in the subsequent vba dialog I entered the following code.
- Private Sub UpdateWarrant_Click()
-
On Error GoTo Err_UpdateWarrant_Click
-
Forms!Vehicleform!VehicleWarrantExp = DateAdd("m", [WarrantTerm], [NewWarrantDate])
-
-
Exit_UpdateWarrant_Click:
-
Exit Sub
-
-
Err_UpdateWarrant_Click:
-
MsgBox Err.Description
-
Resume Exit_UpdateWarrant_Click
-
-
End Sub
This has indeed updated the fields in Question from within the [Vehicleform] however when run from the within the [ClientForm] which is the Parent for the [VehicleForm] I get an error stating that [VehicleForm] "Can-not be found" :/
Yes I have tried
-
Forms!ClientForm!VehicleForm!VehicleWarrantExp =
-
as well as ;
- Forms!ClientForm.VehicleForm!VehicleWarrantExp=
Nearly there