1:M query results

D

DEX

I have an ADDRESS form with a query as the recordsource.
To search I use an ADDRESS form control to pass the query
criteria that incorporate 3 tables in a 1:m 1: m
realationship. If many records are found base on the M
criteria how do I just display the 1 record on my ADDRESS
form?

HELP PLEASE!
 
B

Bill Crawford

Hi:

sounds like your records are displayed on the form in datasheet view

set the form up to use record selectors and you can cycle the records one
line at a time with the next,prev,start,end gadgets.

any good to you?
 
Top