Query with cell reference.

[Guest]

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

 

[Tom Ogilvy]

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))