Requery of Subform
Hi There,
How do you make the focus of my subform stay on the current record after "Requery". I have tried the recordset clone and some other advises of using the current record and "acprevious" but it did not work. my subform is based on a query from a 2 tables ( paypoint which list a unique paypoint and the PIC ) and (access to paypoint list of users who can access the paypoint ), the subform linked to the main form using the "Currentuser" function that is actually user login name and it is also filtered by "PIC". Please advise
cheers
|