viewing/adding in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheRafterMan - 25 Jul 2007 16:58 GMT

I have a form in tabular format with all of these fields, and then all the
data from a table. Now, when i scroll to the bottom, the last record has an
asterisk (*) and all the fields in that last record are blank, so that you
could add a new record through there. How can I have this removed so no
editing/adding could be done in this form?

Reply to this Message

Mr B - 25 Jul 2007 20:16 GMT

Change the following properties of your form:

Allow Additions = false
Allow Edits = false

Signature

HTH

Mr B

> I have a form in tabular format with all of these fields, and then all the
> data from a table. Now, when i scroll to the bottom, the last record has an
> asterisk (*) and all the fields in that last record are blank, so that you
> could add a new record through there. How can I have this removed so no
> editing/adding could be done in this form?

Reply to this Message

TheRafterMan - 25 Jul 2007 20:20 GMT

yeah I did that, but funny story, I have a dropdown in the form footer and a
search box so when you choose a field from the combo and then type in letters
in the search box, it narrows results. with the "Allow Edits = False" i can
no longer type anything into that search bar.

> Change the following properties of your form:
>
[quoted text clipped - 6 lines]
> > could add a new record through there. How can I have this removed so no
> > editing/adding could be done in this form?

Reply to this Message

Mr B - 25 Jul 2007 20:26 GMT

That type of behavior would be expected as the setting of this property is
designed to halt all editing of all controls on the form.

You may need to create another form that you present to the user to allow
for the selection of values for the search and then simply filter your form
to show the desired results.

Signature

HTH

Mr B

> yeah I did that, but funny story, I have a dropdown in the form footer and a
> search box so when you choose a field from the combo and then type in letters
[quoted text clipped - 11 lines]
> > > could add a new record through there. How can I have this removed so no
> > > editing/adding could be done in this form?

Reply to this Message