Set form field on double click

  • Thread starter Thread starter DavisGail
  • Start date Start date
D

DavisGail

I am using MS Access 2003.

I have a continuous form that is run off of a query "srbScientific Review".
The query's criteria is set to [Enter Last Name] in the LastName field. That
part works fine. I get my continuous form that shows LastName, DocID, and
Title of Document.

I would like to double click on the DocID and have the following happen:
1. Open another form "publications"
2. Set the SRBId field to the DocId field that I double clicked on.

PLEASE help. I think I need to bookmark, clone.... I'm very confused.
 
As a kick in the right direction, try update the code of the Double Click
event to:
MsgBox "You clicked the record with DocID: " & Me.DocID
This should show the correct number. You can use this number when opening
the new form either in the WHERE CONDITION or the OPENARGS depending on how
you want to use the DocID.
 
DavisGail said:
I am using MS Access 2003.

I have a continuous form that is run off of a query "srbScientific
Review".
The query's criteria is set to [Enter Last Name] in the LastName field.
That
part works fine. I get my continuous form that shows LastName, DocID, and
Title of Document.

I would like to double click on the DocID and have the following happen:
1. Open another form "publications"
2. Set the SRBId field to the DocId field that I double clicked on.

PLEASE help. I think I need to bookmark, clone.... I'm very confused.
Click to expand...
 
Back
Top