INSERT INTO tabl1 ( [TAG], [Date Received], DPS, [P/N], DESCRIPTION,
CITY )
SELECT parts.[TAG], parts.DATE, parts.DPS, parts.[PART NUMBER],
parts.DESCRIPTION, parts.CITY
FROM parts
WHERE (((parts.[TAG])=[enter the tag number]));
this is the sql for an append query that i have. i created a form that
would use the query in the tag field and then display the addes
records to the tbl1 in my subform while updating.
what i need to know is how to incorporate the append query in the
form? the end result should be sort of a POS, where i have this field
that Im always entering a number and after i enter the number the
query runs and it should be ready for me to enter another number. my
goal is to use the tag field as the query parameter in the form.
cheers,
|
|