making header and footer with code

[tomro1]

I've made a new form but it also needs to have a header and footer, but I can't find how to do that.

Does anyone know how to do that?

 

[Oldsoftboss]

In design mode of the form, go to View on the Menu, then Form Header/Footer (A2000, A2002)

Dave

 

[tomro1]

that i do know, but i want to create it in another form.

example:
form1 --> button1_click()

and then he has to create a header and a footer in form 2

 

[Oldsoftboss]

Is the latest homework creating forms with VBA ???

 

[tomro1]

no, but i'm making an SQL generator and my goal is that i can click 1 button an that access makes me a search form of the recordsource i filled in.

so if i click the button, he makes a new form, puts buttons on it where he puts also code behind and theres where i need the header and footer cause the button has to be put in the header and the textboxes in the details.

 

[Oldsoftboss]

I have been down that track, see post http://www.access-programmers.co.uk/forums/showthread.php?t=123180
(Thus my earlier jibe) and found I rearly used it because every form is different, and I spent more time altering it than what I would have simply creating it from scratch.