Link into a particular record

[Chris]

I need help bigtime

I have a table with multiple fields. Lets say rows 20 fields. I have a sub
form that will display fields 10-20 but I want others to fill these fields
out for me. And I dont want them going into my database.

What will happen is, if possible, I will store hundreds of records and I
want to be able to email my subform out to someone in my office and it will
only point to an existing record and they can update the fields.

EG. I have 200 records, i go into record 100, send an email to user "x" and
they fill out an emailed form, press submit and it will fill in fields 10-20
in record 100 BUT only that record.

Can anyone help. PLEASE!!!!

 

[NetworkTrade]

well....as long as your "subform" contains a unique cross referencing ID of
the main table's record...then when you receive their data back...you can
consolidate this information together via a query. They don't need to see
any of your main table info nor even know that the cross referencing ID field
is there...

but you can't email a form/subform; so you are going to need a different
strategy on this point.

if they have Access then have them log into a specific screen; if they don't
have Access you can consider InfoPath product, or consider sending them an
excel sheet to complete (which you can import easily particularly if it
always has a preset structure defined by you). And of course this must have
your cross referencing value embedded into it each time....