I have a form which has a many text boxes and a combobox. One of the text boxes and the combobox form the composite PK. The value of the PK text box is taken from another from. And based on that I select the combobox values.
eg: I have the first name of a person in one txt box in one form, and the last name in the form of a combobx in another form.
First Name: John
First Name: John (disabled>value taken from Form 1)
Last Name: Drop down of available last names with John as a first name.
List of the other attributes in the table.
Now I want that when I select a Last Name it gives me all the attributes in the respective text boxes. I have done all the needful according to me. But the data in the respective text boxes on selecting the Last Name does not give me anything. When I go ahead and try to update any field it gives me an error: "Update or CancelUpdate without AddNew or Edit".
Please tell me what to do.