I am trying to pull up records that are linked from two separate
tables. The fields in play and their characteristics are listed
below. Two table are being utilized, Registrations (Name, Reg #,
other data) and Division/Winners (Div #, Description, First, Second,
etc).
Enter_data - text box - User types in the division they want to view
Show division - List box - Table =Division/Winners. Updates based on
what is
typed in control source Enter_data. Includes Div #.
First - Text box - Table =Division/Winners. Is to show Reg # of
whomever won
first in division selected above. Control Source Div #.
First_data - List box - Table =Registrations. Shows remaining info
for
whomever got first place. Control Source First.
My Problems: Show_Division updates fine when typing in Enter_data but
does nothing when
paging up/down. I would like it to move to the next division.
First updates but it is not showing the division selected. It is just
going
up a record every time I press enter or page up/down. So, the
Show_division
and the winner being shown is not from the same record.
I would really apprieciate any help. I am rather new to Access and
am
learning lots but have a long way to go.
Thanks for your help.
Sharon
