M
mcnews
is there a better way to update a row on a continuous form than
form.requery.
this app uses a SQL backend. the form in question is connected to a
multi-join query that contains over 61,000 rows. i have explored
every avenue of limiting the recordset, but the users insist that all
rows be available for scrolling. the problem is that when field A is
updated a lookup is performed that populates field B. what is
happening is that the database row updates but the screen does not, so
i have to do something to force the form to update. everything i've
tried is too slow for the users and they complain.
i need some ideas.
thanks,
mcnews
form.requery.
this app uses a SQL backend. the form in question is connected to a
multi-join query that contains over 61,000 rows. i have explored
every avenue of limiting the recordset, but the users insist that all
rows be available for scrolling. the problem is that when field A is
updated a lookup is performed that populates field B. what is
happening is that the database row updates but the screen does not, so
i have to do something to force the form to update. everything i've
tried is too slow for the users and they complain.
i need some ideas.
thanks,
mcnews