Re: Go to the specified form

Acores,
Database fixed and returned...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"acores" <acores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D6A3850-0E20-4B64-BF13-1CA6A4DBC400@xxxxxxxxxxxxxxxx
Hi, Al Camp.

Once again, thank you for your effort.

I have one main form when I enter all the information needed for each record
- this form name is «frm_Obras». I have a field on this form called «Obra_ID»
(not visible).

Then I created a new form where only the most important «Frm_Obras» fields
will be shown - it's a continuous form called «frm_Lista_de_Obras». I
included in this one the «Obra_ID» field also (not visible too).

My purpose is: the user begins to see the continuous form
«frm_Lista_de_Obras» and if he wants to edit a specific record, he just
double click in a certain field (in this case, the field «Obra_ref»), and
jumps to that (and only) specific record.

Yesterday, what I have done with your help was: I entered the following
procedure in the double click procedure in the field «Obra_ref», of the
«frm_Lista_de_Obras»:

Private Sub Obra_ref_DblClick(Cancel As Integer)
DoCmd.OpenForm "frm_Obras", , , "Obra_ID = forms!frm_Lista_de_Obras!Obra_ID"
End Sub

But when I double click in this field, just opens a empty record of the
«frm_Obras».

Have I done something wrong?

Thank you again for your help.

Regards.

Acores


"Al Camp" escreveu:

First of all, thank you for your quick answer. However I tried to apply your
solution, but it didn´t worked.

Please show me the exactly the code you used, and describe in detail where you
entered
that code.
Also, what is the name of your main form, the name of your subform, and the name of
the
form you want to open.

Your code should be in your Form Module within the field DoubleClick event.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



"acores" <acores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:30359F47-4844-4CAA-BA44-692F6A10051C@xxxxxxxxxxxxxxxx
Hello, Al Camp.

First of all, thank you for your quick answer. However I tried to apply your
solution, but it didn´t worked.

Could you be more clear about it, please?

The real situation is: I have a continuous form, called
«frm_Lista_de_Obras», in which I want no double click in a certain field
«Obra_ref» and jump to the specific record in another form, called
«frm_Obras». They have both a auto number field (not visible) called
«Obra_ID» (primary key).

Another question is: what can I do to, once opened the required record, not
allow the user to go to the other records? I just want the user to open, edit
and close the form.

Thank you again, and sorry for all this questions.

Best regards.

Acores


"Al Camp" escreveu:

Acores,
First, When a field is Enabled but Locked, the data can not be altered, but it
will
react to the Double Click.

What you're doing is what I call a "Jump" field. A continous form displays
records,
and when you click a certain field on any record, a form opens to display the
details
of
that record, and allow for editing of that "supporting" data.
I usually use color any jump field as dark red with white font so the user
always
knows that that color, anywhere in the app, is a jump field.

Each record should have a unique key value, say for example CustomerID. It can
be
hidden on your continuous form.
Use the Where argument in the OpenForm method to specify what record you want to
Open
on.
On the Dbl-click of the something convenient like the CustomerName...

DoCmd.OpenForm "frmCustomers", , , "IDNo = Forms!frmYourListForm!Form!CustomerID"

Use your own object names and... my code assumes your "calling" CustomerID is on
a
Main
form, not a subform.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"acores" <acores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13B36FBB-2D1C-49B5-8136-3D16F3C087C4@xxxxxxxxxxxxxxxx
Hello.
I have a form which only purpose is to show the result of a query (just some
form fields). This information is to be protected (read only); however I
would like to make a certain field active in order the user to double click
and to open the respective form.
I allready tried to do a macro and it works partially, because when I double
click in the 5th record (for example), it opens allways the record number 1
and I have to go to the specified one (number 5). How can I go directly to
the number 5?
Can anyone help me?
Thank you in advance.








.

Relevant Pages

  • Re: Go to the specified form
    ... Only difference is that I "call" the jump from a subform. ... Candia Computer Consulting - Candia NH ... the user begins to see the continuous form ... But when I double click in this field, just opens a empty record of the ...
    (microsoft.public.access.forms)
  • Re: Go to the specified form
    ... the user begins to see the continuous form ... But when I double click in this field, just opens a empty record of the ... Candia Computer Consulting - Candia NH ... What you're doing is what I call a "Jump" field. ...
    (microsoft.public.access.forms)
  • Re: Passing Values from One Form to Another Including a Combo Box
    ... Candia Computer Consulting. ... I keep getting an error "Switchboard can't find the form", ... The Main form is frmPatientHistory, ... switchboard, it opens fine. ...
    (microsoft.public.access.formscoding)
  • Re: Go to the specified form
    ... Candia Computer Consulting - Candia NH ... I have a continuous form, ... and when you click a certain field on any record, a form opens to display the details ... I usually use color any jump field as dark red with white font so the user always ...
    (microsoft.public.access.forms)
  • Re: Main form -subform keeping count
    ... If dispatchdetailsquery contains DispatchID and ContactedWork (Boolean) ... Candia Computer Consulting - Candia NH ... Wanted to tie it to the dcount of the field in the subform call [contacted ...
    (microsoft.public.access.forms)
Loading