1:M query results

  • Thread starter Thread starter DEX
  • Start date Start date
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!
 
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?
 
Back
Top