Query with cell reference.
 

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

Query with cell reference.
 

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