Queries on Forms for User Input

H

hermanko

I have a database set up to import Fund Mapping data from different
sources (i.e. business units). The data itself is simple, my fields are
"Fund Name", "Proxy" and "Business Unit". Each time a different
Business unit sends data to be imported into the main database, i have
some duplicate queries set up to weed out duplicates. There are two
situations for duplication:
1) repeating Fund Name from different business units, using the SAME
Proxy as well.
2) repeating Fund Name from different business units, using a DIFFERENT
Proxy.

so, first i import new data into the main database, which may contain
duplicates now. i set up one query to extract all reepating Fund Names
regardless of proxy. then i use two more queries to extract into
separate results, 1)duplicate fund names with same proxy and 2)
duplicate fund names with diff. proxy.

Here is where i get stuck. I need to show these results on a form (or
two separate forms for each situation) where the user can click an
option group radio button to manually select which of each duplicates
he/she wants to keep, then remove the other record from the main
database. I have no idea how to get query results shown on a form,
because it's dynamic (i.e. there wont always be the same number of
duplicates when i import new data).
 
M

mscertified

You could show the query results in a Listbox which is scrollable.
The 'Row Source' property would be set you your query name.
Look up 'Listbox' in Access Help.

-Dorian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top