Stop subform from scrolling to new record line

[Chris Freeman]

I have a subform that displays bank info for an employee paycheck. The bank
info data comes from a separate file and the employee paycheck is from
mainframe system.

The form works fine, but when the user clicks on on of the subform fields to
enter data, they can scroll to next record like adding a new record. I've
tried selecting no additions on subform only, but this blocks the subform
from the displaying any fields from any main form records that have no
corresponding subform data.

I want the user to be able to enter data on the subform, but not to be able
to scroll or tab through to the next record.

Thanks in advance.

 

[John W. Vinson]

I want the user to be able to enter data on the subform, but not to be able
to scroll or tab through to the next record.

I'm sorry, but this sounds like a direct contradiction. You want them to be
able to "enter data" - new records I presume - but not be able to "enter data"
- the new record.

And the subform will not show existing records that aren't related to the
mainform record if the subform's master child link fields are set correctly.

Please clarify!

 

[Chris Freeman]

John, to clarify, the user sees Chris Freeman, Los angeles, CA on main form.
There's a subform with fields, some populated through the import: bank: bank
of america, chekc amount: $32.00, then there are some open fields to be
populated by the user: New Check Number: Void process:.

The problem is that when the user is in the subform, they can tab through
the fields, and when they reach the last field, pressing tab again will take
them to a new record line. the same way you would do if you were in a regular
form or spreadsheet view. But I don't want them to be able to roll over to
this new blank record. I have a Save Record button for them to click to save.

Its an aesthetics issue. The system doesn't allow them to create a new
record through the subform as this is locked by the unique record function,
but it just works funky and causes some user confusion.

 

[John W. Vinson]

John, to clarify, the user sees Chris Freeman, Los angeles, CA on main form.
There's a subform with fields, some populated through the import: bank: bank
of america, chekc amount: $32.00, then there are some open fields to be
populated by the user: New Check Number: Void process:.

The problem is that when the user is in the subform, they can tab through
the fields, and when they reach the last field, pressing tab again will take
them to a new record line. the same way you would do if you were in a regular
form or spreadsheet view. But I don't want them to be able to roll over to
this new blank record. I have a Save Record button for them to click to save.

Its an aesthetics issue. The system doesn't allow them to create a new
record through the subform as this is locked by the unique record function,
but it just works funky and causes some user confusion.

OK... so you want to be able to *EDIT* the existing record, but not to add new
records. I would think <goes to test it... yep...> that you should be able to
set the Subform's Allow Edits property to Yes, Allow Additions to No; and set
the form's Cycle property to Same Record. Does this not work for you?

 

[Chris Freeman]

John,
The problem with setting the subform to Editable but No Additions, is that
when the user scrolls to a record with no corresponding record in the subform
table, the subform shows up blank. I guess I could add a "New Record" button
that would populate the table with the corresponding Property ID, the field
that links the two tables. Upon populating the property id value into the
table, then I could refresh the record and the form would display the fields.

OK, then how do I set the form visible to False if there is no corresponding
record?

 

[Chris Freeman]

John,
I've decided to compromise here. I've set the form2 to editable, no
additions. This provides me with a blank space when there is no matching
record, so I added a button, "Create Record", which adds the Prop_ID value to
the form2 table, refreshes the form and viola, the form and fields appear.
this works fine.

I'd like to take it to the next level, and have the form go invisible if no
matching record appears. So the user sees both forms, and as they scroll,
when Form2 has no matching record, the Form2 disappears, and the button
behind it appears. Then the user click the button, the Form2 table gets
updated and the from gets refreshed and appears, covering the button.