Why not have your query come in on one sheet, then use formulas (like
Vlookup) on your "form" sheet to populate the appropriate locations.

=if(b2="","",Vlookup(B2,Table,2,False))

--
Regards,
Tom Ogilvy


"G. Wolfe" wrote in message
...
Hopefully this makes sense or maybe it just can't be done.
We have a bad habit around here re-typing about 5 or 6 different fields of
information on every form we use. Most of the forms are in excel. I
would
like the user to request a specific record by part number (from Access)
and
the other 5 fields come into the excel form into the corresponding cell.
For
example; Part Number:B2, Part Name: B3, Mold Number: N3 and so on.
Is
this possible??

I have setup my query, but when I import the information it brings in the
requested record all on one row. Also, the titles of each field are
imported
too.

Thanks!!
G. Wolfe