Hello --
Does anyone have a suggestion for resolving my problem which is described in
general terms below?
If more information is required as to structure, keys, form function, etc.,
I will be happy to provide it.
My question, from what I think I am seeing:
Is there a difference between appending records and adding them via a form,
assuming that appending or form entry does not violate a primary key?
Background:
Application handles management of an investment portfolio
A table's primary key = AccountID & OwnerID & Symbol & LotNumber
An application (FE/BE) has been working correctly for user #1..
I copied the BE for user #2, and did the following:
- deleted records from the data tables
- appended records user #2 created in an Excel worksheet
Problem:
[a]
Selecting a record (from a listbox of key values for all records) and then
displaying that record in a form results in Error 2427
"You entered an expression that has no value" in the Form_Load event.
The expression that has no value in the form is Symbol. Symbol is used to
determine which fields in the form are enabled.
If I add a record using the features of the app, rather than appending it,
the error does not occur, and I am able to view the record using the
procedure in [a].
User #2's table has 1100 records, so I would prefer to figure out how to
append them, rather than ask user #2 to enter them manually.
All records are viewable in user #1's BE.
Is this enough of a description of the environment and problem for someone
to give me an idea of what I have to fix?
Thanks in advance for any comments.
Larry Mehl
|
Similar Threads
