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
|