K
Kelly
I've created a Customers dbs and Renew dbs. CustomerID is
prim key on both. Created 3qry's: qryCustomers, qryDetails
& qryRenew. Also created 3 forms to display all this
info. Problem is, say when I go to record 3 (or 4, 5,
etc., on the 2nd or 3rd form, it reads that I'm on record
1 of 1 Filtered. On the first form, it shows that I'm on
record 3. If I try move to a new record on that form,
Access acts like there are none. I want to make the 3
forms part of a whole event where can I enter data into
the forms and at end, print a report on contract renewable
dates. Created 2 macros to have all 3 forms update the
records on an Open command button, but I'd like to be able
to move forward and backward a record if needed, on form 2
and 3, and have that particular record show up on each
form I move to. Any help would be appreciated.
Thanks, Kelly
prim key on both. Created 3qry's: qryCustomers, qryDetails
& qryRenew. Also created 3 forms to display all this
info. Problem is, say when I go to record 3 (or 4, 5,
etc., on the 2nd or 3rd form, it reads that I'm on record
1 of 1 Filtered. On the first form, it shows that I'm on
record 3. If I try move to a new record on that form,
Access acts like there are none. I want to make the 3
forms part of a whole event where can I enter data into
the forms and at end, print a report on contract renewable
dates. Created 2 macros to have all 3 forms update the
records on an Open command button, but I'd like to be able
to move forward and backward a record if needed, on form 2
and 3, and have that particular record show up on each
form I move to. Any help would be appreciated.
Thanks, Kelly