Forms and Tables

[cor]

How do I disable the 'Record No:' at the bottom of a form?
I chose to hide the header and footer resulting in not showing the
'Record No:' and navigation at the bottom, however, it still sends the
input data to the Table regardless.
What I would like is for the user to press a send buttom and only then
should the Table be updated.

Thank you.

 

[Guest]

Dear Cor,
If you have the form open in Design View, Right click the form (black square
in the top left corner at the junction of the rulers) and select Properties.
Here you can enable or disable bits of the form at will. Under the Format
Tab, you will see the the "Record Selectors" item (5th one down). Double
Click to the right of this item and to toggle between YES and NO or click the
down arrow and select NO.
--
Cheers
Chas

***************
* Spectrum is Green *
***************

 

[Brendan Reynolds]

The record number indicator is part of the navigation bar, which also
includes the first, previous, next, last and new record buttons. It can be
hidden by changing the 'Navigation Buttons' property of the form. There is
no way to show or hide individual items on the navigation bar.

Note, though, that whether the navigation bar is shown or hidden has no
bearing on the automatic saving of records. Bound forms will always
automatically save changes, that is the nature of bound forms. If that's not
what you want, you can use unbound forms, but then you have to write your
own code to retrieve, navigate, and save records.

 

[ceebee]

Thank you for the advice.
I'll use an unbound form to create the form and code what i need to do.
Cor

 

[Guest]

If you go into the properties of the form and select the Format tab you can
remove the navigation bar by changing the Navigation Buttons to No.
Then using the toolbox you can create a Command Button to add the record and
move to a new one.

Hope this helps