E
E. Kwong
On Form1 I have a list control whose row source is a
query. When a row is doubleclicked, the record ID is
passed to Form2 to display the specific record in full and
refresh the Form1 display in the form_afterupdate sub.
Now my user got stucked once in a while: No matter which
row she doubleclicks, it will go to the SAME record. At
first I couldn't find out the cause and I just had the adp
re-installed. I did turn on debugging and check that the
correct record ID is passed.
This situation happened several times already: user edits
several records successfully, then got stucked on a single
record. We finally found out the cause recently: a
record ID is showing in the Server Filter field on the
property sheet of Form2. How it got there remains a
mystery to me. I'm thinking maybe the refreshing
(requery) on Form1's list control from Form2 has something
to do with it. Any insight appreciated.
query. When a row is doubleclicked, the record ID is
passed to Form2 to display the specific record in full and
refresh the Form1 display in the form_afterupdate sub.
Now my user got stucked once in a while: No matter which
row she doubleclicks, it will go to the SAME record. At
first I couldn't find out the cause and I just had the adp
re-installed. I did turn on debugging and check that the
correct record ID is passed.
This situation happened several times already: user edits
several records successfully, then got stucked on a single
record. We finally found out the cause recently: a
record ID is showing in the Server Filter field on the
property sheet of Form2. How it got there remains a
mystery to me. I'm thinking maybe the refreshing
(requery) on Form1's list control from Form2 has something
to do with it. Any insight appreciated.