I have two tables, both have a unique field (AFS). How do I code a textbox
that shows only those AFS's that match in both tables?
A *textbox*? What if there were 33812 records which matched? What do
you want to see on the screen? It would need to be a rather large
textbox!
You can create a Query joining the two tables by AFS, and select
whatever fields you would like to see from this Query; you can then
base a Form (for onscreen viewing) or Report (for printing) on the
query.
John W. Vinson[MVP]
