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






"CarolM" <(E-Mail Removed)> wrote in message
news:9D30DF2E-C739-422D-83CE-(E-Mail Removed)...
> 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
>
>

Hi John

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

The button works fab!

Thanks for your help

Carol

"JohnFol" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:9D30DF2E-C739-422D-83CE-(E-Mail Removed)...
> > 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
> >
> >
>
>
>