Record #'s won't change on forms

[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

 

[Mark Phillipson]

Kelly,

If the form says 1 or 1 Filtered then there is a filter applied. To remove
the filter and show all records on the menu select Records>Remove
Filter/Sort.

If you wish to synchronise forms. By far the easiest way is to create a sub
form within the main form. To create a sub form from disign view of the
main form draw on the Sub Form control and follow the wizard. Remember to
select the Primary key (link master fields) and Foriegn key (link child
fiields) so that the sub form will automatically synchronise.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/