G
Guest
Hello. I am having a dillemma with a field filling when a cbo is used. I
have a main form that has different fields on it. These are bound to the
table in an after update event of the cbo. The cbo on the form that is used
to select the record and the other fields fill in using the following code;
dim rs as object
set rs = me.recordset.clone
rs.findfirst "[reviewID] = " & str(me![cboSelectReview])
me.bookmark = rs.bookmark
I have used this many times before and the same process of binding the form
to the table and it all works.
What is occuring now and I am at a loss why, is that the one field
"cboClaimStaffID" does and doesn't fill in at times. All other fields work
correctly except this one field. I have retraced steps, any coding, queries,
etc and can not see the problem.
Has anyone come across this and if so what was the fix?
Thanks. If better explanation is needed, let me know.
*** John
have a main form that has different fields on it. These are bound to the
table in an after update event of the cbo. The cbo on the form that is used
to select the record and the other fields fill in using the following code;
dim rs as object
set rs = me.recordset.clone
rs.findfirst "[reviewID] = " & str(me![cboSelectReview])
me.bookmark = rs.bookmark
I have used this many times before and the same process of binding the form
to the table and it all works.
What is occuring now and I am at a loss why, is that the one field
"cboClaimStaffID" does and doesn't fill in at times. All other fields work
correctly except this one field. I have retraced steps, any coding, queries,
etc and can not see the problem.
Has anyone come across this and if so what was the fix?
Thanks. If better explanation is needed, let me know.
*** John