autoform and making my own

[bluesage]

hi, its easy to make an autoform, but i would like to make a form my self with which we can add, delete, and see all the records in a table, or even in all my tables.

can anyone give me some help? w/ code is welcome

i tryed using cmd buttons, with find next record, but im having problems

thanks

 

[mph1]

If I understand you correctly, when you click on New Form, choose the first option ----- Design View. By doing this you will create an unbound form. From there you can choose what table/query, if any you want the form to be bound to. Then you can choose whatever object you wish. However, I would think you would want to choose the table/query from the drop down. By doing this, you can then create your own add, delete etc buttons for navigation.

HTH


An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[bluesage]

would it possible to post an example? it would be easier to understand, im not too sure what you're explaining.

thanks

 

[PHV]

Why not first using the wizard ?
It would generate for you a good example with your objects.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bluesage]

the problem with autoform is that the record navigation is not changeable, i cant see the code behind it, because it is in the navigotor section.

i want to personilize the navigation.

 

[Crowley16]

how exactly do you want to personalise it?

move forwards 2 recs at a time? Move to specific records...?

 

[bluesage]

personilize in the sense that i dont want to have the navigation bar, instead in the form, have buttons i create which do the same thing.

 

[Crowley16]

well, first use the wizard to create the form, then goto form design...

on your format section, set the "navigation buttons" property to false

then create 2 command buttons on your form, and in thier code put the lines:
Me.Form.recordset.MoveNext
Me.Form.recordset.MovePrevious

 

[mph1]

Crowley16 is correct in his explanation. When you are making a new form using the autoform, what you are doing is choosing the look of the form. You can also choose the columnar, which is the single form view. After you have created a new form, go to the properties, in disign view, of this form and change the Navigation Buttons to NO. This will eliminate the built in navigation. Then you can make your own navigation buttons. One way to accompolish would be to use the wizard while clicking on the command button to add to your form. Also, the autoform you refer to can be changed in the desing view by going to the Defaul View in the properties of the form.

One other suggestion --- while in the desing view of the form, go to properties of the form and try changing the values of Scroll Bars, Record Selectors and Navigation and some of the other options. Do one at a time and then go to from view to see what effect it creates.

Hope this is of some help.

Maurie

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106