problem with the updating form

[ngeng4]

yerp. im still new to access and still in the process of exploring it. hope u guys can help me with all my silly question.. thank you very much... mine is case 2.

[maximus]

Please mark this thread solved as it will help others having the same problem to find quick answers. Glad could help you!!!

[maximus]

is your problem solved if yes mark the thread solved.

[ngeng4]

still didnt work..

[pbaldy]

Can you post the db?

[ngeng4]

okay,, here is my db

[maximus]

I have lokked into your database. here are the problems with you form:

you have put the following code in the project_updating Activate Event:

Private Sub Form_Activate()

DoCmd.Maximize

If Not Me.NewRecord Then
DoCmd.RunCommand acCmdRecordsGoToNew
End If
End Sub

Which is absolutely unecessary


You have put the following code in the Activate Event of Project maintainance Form. Which too is not necessary



Private Sub Form_Activate()

Dim stDocName As String

stDocName = "Project Maintainance"
DoCmd.OpenForm stDocName, , , acFormEdit

End Sub



I have change the code of the Project Updating and Project Maintainance and have removed the unecessary codes. Check the attachments.
One more question did you enter any test data. Checked you relationships Transmaster has no data in it thus when I am opening Project Maintainence form it displays no data. Check that will you.

I have included two buttons along side your ones check them out.

[ngeng4]

yerp. ive try to enter a test data. but still didnt appear anything. and about the transmaster table. i dont get you. if not how can i relate the project table and others?

[maximus]

First of all are the buttons working. If Yes the second problem. Enter data open project Maintainance form in design view. go to Record Source. Open the query and run it see if the query displays any data if not i have to check the relationships.

[ngeng4]

whres the button? is that in the project maintainance form? i cant see any button, 2nd, ive run the query. it didnt work.still blank

[maximus]

here I have entered some data just following your relationship and project _maintainance form displays data

[maximus]

Check Main Menu form

[ngeng4]

its work!!!! thank you very muchhhhhh

[maximus]

This has to be the longest thread in the history of this Forum

[ngeng4]

hee.. sorry. im really2 new to this. so have to ask about almost everysingle small thing..