G
Guest
hello,
I recently upgraded to Access 2003. I am using an unbound form with unbound
combo box and a subform.
I have tried this technique regularly in Access 2002, and on Northwind in
2003.
Basically on Form1, I have cbo_Field1. The selection in cbo_Field1 is the
parent child link to the subform(sform1). Like a filter. sform1 is a
continuous form.
I select the value, and the appropriate records are displayed in sform1.
Problem is when I try to add a record in sform1. Field1 in sform1 is
populated (as expected) with the value of cbo_Field1 from form1. When I
attempt to enter something (on dirty i assume) in other fields in sform1, I
get an error....
An error occurred while referencing the object.
You tried to run a Visual Basic Procedure that improperly references a
property or method of an object.
I do not have any code in visual basic on the two forms used.
Since I can do this technique in Northwind, I assume the problem is with the
record source table. The record source of sform1 is the underlying table.
The underlying table only has one indexed field ID (which is also the KEY
field).
This is driving me crazy. If anyone has any thoughts of why this is
occuring, I would appreciate your insight.
I recently upgraded to Access 2003. I am using an unbound form with unbound
combo box and a subform.
I have tried this technique regularly in Access 2002, and on Northwind in
2003.
Basically on Form1, I have cbo_Field1. The selection in cbo_Field1 is the
parent child link to the subform(sform1). Like a filter. sform1 is a
continuous form.
I select the value, and the appropriate records are displayed in sform1.
Problem is when I try to add a record in sform1. Field1 in sform1 is
populated (as expected) with the value of cbo_Field1 from form1. When I
attempt to enter something (on dirty i assume) in other fields in sform1, I
get an error....
An error occurred while referencing the object.
You tried to run a Visual Basic Procedure that improperly references a
property or method of an object.
I do not have any code in visual basic on the two forms used.
Since I can do this technique in Northwind, I assume the problem is with the
record source table. The record source of sform1 is the underlying table.
The underlying table only has one indexed field ID (which is also the KEY
field).
This is driving me crazy. If anyone has any thoughts of why this is
occuring, I would appreciate your insight.