Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select a single record in continuous forms to copy to another form

Status
Not open for further replies.

rxsims

Technical User
Jul 14, 2003
34
CA
I need to copy information from a single record in a continuous form (this is really a subform, but I don't think it should matter) into another form.

In each line/record of the continuous form, I have a Yes/No box, that when clicked will open another (different) form. Once the new form is opened I want to copy (by code) some information from the original line/record, of the first form.

I can't figure out how to select just the one line of the continuous form for copying.

Any help is greatly appreciated.
 
Hi
I have done something similar with journals by library. I think you will find that if the user has clicked a record in a continuous form, you can access data from that record.
For example, I have:
vFind = "[Title Code]=" & Forms![Members]![Jnlsmem subform].Form![Title Code]
which gives me the unique identifier of the currently selected record. I can then use this information to find the record in a recordset. You could just save each field you want to a variable. Why not check it out with a message box?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top