Does any one out there know ?

[ayeshamiah]

anything about how access treats forms that are being maximized

Thanks to all you have tried to help to my previous question, but I don't think you have understood

this site has always disappointed when it has come to giving answers invoving any VBA code.

 

[Carol]

Put the following code in the On-Load of each form, setting its properties to Pop-Up:

Private Sub Form_Load()
On Error GoTo Form_Load_Err

DoCmd.Maximize


Form_Load_Exit:
Exit Sub

Form_Load_Err:
MsgBox Error$
Resume Form_Load_Exit

End Sub

If you are using the cut and paste method, Access may at times corrupt the coding, in which case, delete the coding altogether from the form and set it again.

One other thing, if you have any forms that are based upon queries for its recordset that have a parameter set, you might also get an error in opening the form to its maximum size. This is only applicable to the actual form itself and not any subforms or fields contained within it.

Good luck

 

[Richie]

We do understand you have a problem that no one else has had and you seem to be blameing them for not providing you with a quick fix, slagging other members off who are trying to offer help is neither benificial or gracious, if the site is useless as far as you are concerned why bother using it? What research have you carried out yourself to solve the problem?

 

[ayeshamiah]

Many thanks for your help caroline and,

You have opened my eyes. It explains why the code has been behaving erracticly. I have now resolved all the issues. Many thanks again

My apologies Richie and all members for venting my frustration out on the forum, it was wrong and very childish.

Secondly I do not rely on others to provide me with answers/solutions if I did I'd be out of a job by now.