Hi
Self taught user of access and I have the following problem in Access 2003.
I have a form with 2 continous subforms. All the data has been added and all information is correctly linking.
I can re-open the form and add additional information in the the 2 subforms with no problem.
However when I re-open the form and try to edit a record on the main form I get the following error when I try to move on the the subform or save the record:
- compile error - invalid use of property.
This then open the VBA window and highlights the following VBA code:
Private Sub Form_AfterUpdate()
Form [Mileage Expense Form].Form![SubFMileageInfo].Requery
End Sub
This error message does not appear when the main form record is initially created and details are input into both subforms.
The changes made to the main form are in fact still there but I do not know how to alter or add to the code to allow changes to the main form and remove the error.
The main form holds employee details.
1st subform - SubFSiteInfo - hold site details [link field is employee ID to main form]
2nd subform - SubFMileageInfo - holds employee travel information relative to the specific sites they are on. [Link fields are to EEID on main form, and SiteContractNo. on 1st subform]
Any advice would be much appreciated.
Thanks
Shona