open one form from another but display same record information

[DH010010]

I have one form (customer and job details) that display details from a table.
now i have another form (estimate Details) that opens when i click an option
on the customer details form. the problem is the estimate form opens from the
last record but i want it to display details from the record it was activated
in. can this be done?

 

[Wayne-I-M]

Private Sub SumeButton_Click()
DoCmd.OpenForm "Form to open name", acNormal, "", "[ID]=[Forms]![form you
are on]![ID]", , acNormal
End Sub


Change
form to open
form you are on
ID

to what they really are

 

[Kevin Lingley]

Hi There,

I have exactly the same issue and the answer looks great, but forgive me for being really dumb but what does ID refer to?

thanks in advance

Kevin

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

 

[Jeff Boyce]

Kevin

You'll want to post your reply as a reply to an earlier post rather than
starting over as you have...

It will make it easier for folks to see the context of your question.

I'm going to guess that you'll need to use the name of your row/record ID
field. The expression:

Forms!CaseRecord!ID

refers to a control called "ID" on a form named "CaseRecord".

Substitute your own form name and control name...

Regards

Jeff Boyce
Microsoft Office/Access MVP