query based on form data

[patrichek]

Hi,
I'm trying to create an append query based on an open form. I want to take the record that is open in the form and send it off to another database. When I make my query it returns the same record 2853 times (thats the number of records in my db).
what am i doing wrong?
My query fields:

Expr1: [Forms]![Contacts]![contactIDtxt]
Expr2: [Forms]![Contacts]![FirstName]
Expr3: [Forms]![Contacts]![LastName]

now here's my code:

SELECT [Forms]![Contacts]![FirstName] AS Expr2, [Forms]![Contacts]![LastName] AS Expr3, [Forms]![Contacts]![contactIDtxt] AS Expr1
FROM Contacts;

thanks!

 

[PHV]

A quick and dirty way:
SELECT DISTINCT ...

Another way is to use the INSERT INTO ... VALUES (...) syntax.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[patrichek]

THANKS! that solved that problem now i need to figure out my key violation?

someday PHV i'll show you the db you helped me build!