Copy data from filtered record

[Guest]

Hi,

I have tried to find through the newsgroups how to copy data from one record
to another with very limited success.

I have a form (Property Details), I also have aother form (Comments). In the
Property Details form I have a button which opens the Comments form filtered
on the PropertyID in the Property Details form.

The Comments form allows for new entries, what I would like to do is copy
the PropertyID value from Propery Details and paste the value into the
PropertyID field in Comments form.

How do I achieve this.

Thanks in advance for your responses.

Regards

Gary O

 

[Duane Hookom]

You might be able to set the default value of the PropertyID in the Comments
form to Forms![Property Details]![PropertyID]. You can also send the
PropertyID to the Comments form in the OpenArgs.

 

[Guest]

Thanks Duane,

I used the first option as I understood how to do that.

Regards

Gary O

You might be able to set the default value of the PropertyID in the Comments
form to Forms![Property Details]![PropertyID]. You can also send the
PropertyID to the Comments form in the OpenArgs.

--
Duane Hookom
MS Access MVP

Hi,

I have tried to find through the newsgroups how to copy data from one
record
to another with very limited success.

I have a form (Property Details), I also have aother form (Comments). In
the
Property Details form I have a button which opens the Comments form
filtered
on the PropertyID in the Property Details form.

The Comments form allows for new entries, what I would like to do is copy
the PropertyID value from Propery Details and paste the value into the
PropertyID field in Comments form.

How do I achieve this.

Thanks in advance for your responses.

Regards

Gary O