linking a specific record to a matching record in another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a form that lists different records

the form is made up as:-

dateonletter reply refno name prod issue resolved

3/5/2005 6/5/2005 1785 johnsmith car broken yes

i have another form that holds more in depth details about each record. What
i would like to do is click on the reference number and the dailylog form to
open at this specific record.

I have created a macro that is an openform and entered this in the "on dbl
click" in the properties. What i cant work out how to do is to go to this
specific record in the dailylog form?

Can anyone help please?

thanks in advance

Carol
 
The macro for OpenForm allows you to specify a few arguments such as a Where
condition. In your case you want the RefNo to match
Can I suggest you make life easy on yourself and use the button wizard? It
will prompt you for the 2nd form, and which dields need to match and will
generate code similar to :


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Customer Orders"

stLinkCriteria = "[CustomerID]=" & "'" & Me![EmployeeID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Hi John

Not quite what i had in mind but the best laid plans :)

The button works fab!

Thanks for your help

Carol

JohnFol said:
The macro for OpenForm allows you to specify a few arguments such as a Where
condition. In your case you want the RefNo to match
Can I suggest you make life easy on yourself and use the button wizard? It
will prompt you for the 2nd form, and which dields need to match and will
generate code similar to :


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Customer Orders"

stLinkCriteria = "[CustomerID]=" & "'" & Me![EmployeeID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria






CarolM said:
Hi

I have a form that lists different records

the form is made up as:-

dateonletter reply refno name prod issue
resolved

3/5/2005 6/5/2005 1785 johnsmith car broken yes

i have another form that holds more in depth details about each record.
What
i would like to do is click on the reference number and the dailylog form
to
open at this specific record.

I have created a macro that is an openform and entered this in the "on dbl
click" in the properties. What i cant work out how to do is to go to this
specific record in the dailylog form?

Can anyone help please?

thanks in advance

Carol
Click to expand...
Click to expand...
 
Back
Top