Search and Get Stuck

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

I am utilizing Allen Brownes' search form to find a record which
happens as it should. Once found, I now want to double click a field
IDNUM to open up a single form to edit existing data matching that
IDNUM field.
There are no subforms involved. I have read several older posts and I
just don't get it. If there is specific info you require from me to
determine where I'm going wrong please let me know.

Could someone please explain the process and suggest some code? Thanks
 
Hi TeeSee

You should execute an OpenForm command similar to the following:

DoCmd.OpenForm "Name of your form", , , "[IDNUM]=" & Me![IDNUM]
 
Hi TeeSee

You should execute an OpenForm command similar to the following:

DoCmd.OpenForm "Name of your form", , , "[IDNUM]=" & Me![IDNUM]




I am utilizing Allen Brownes' search form to find a record which
happens as it should. Once found, I now want to double click a field
IDNUM to open up a single form to edit existing data matching that
IDNUM field.
There are no subforms involved. I have read several older posts and I
just don't get it. If there is specific info you require from me to
determine where I'm going wrong please let me know.
Click to expand...
Could someone please explain the process and suggest some code? Thanks- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Graham ... A sincere thanks for the reponse. I still have the same
problem as follows. Actual field names!

The field [FileNumber] is the field on frmSearch to be double
clicked.
[ctlFileNumber] is on the form being opened.


Private Sub FileNumber_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmMSDSdataInput", , , "[ctlFileNumber]=" & Me!
[FileNumber]
End Sub

Graham .. This is what I don't understand. I believe I have the syntax
correct as you described buy I still get a "Enter Parameter Value" box
looking for a value for [ctlFileNumber]
In the DoCmd line what I would like to understand is .... The position
of the first fieldname (in this case [ctlFileNumber]) is on the form
being opened and the second (Me![FileNumber]) refers to in my case the
search from which is the currently opened form.

Do I have this correct?
Why do you think I am getting the Enter Parameter Value
request.ingsterm
 
Hi TeeSee

Is "ctlFileNumber" the name of a field in the recordsource of
frmMSDSdataInput, or is it just the name of a control on that form?

It should be the name of a field in the recordsource.

If you have, for example, a textbox named ctlFileNumber and it has as its
controlsource a field named FileNumber, then your OpenForm where condition
should be:
"[FileNumber]=" & Me![FileNumber]

The [FileNumber] on the left is the name of the field in the recordsource of
the form you are opening and the one on the right is the name of the textbox
on the current form (frmSearch).

It will take the *value* in the textbox and append it to the "[FileNumber]="
string to give:
[FileNumber]=12345

Also note that if [FileNumber] is a text field you need to do it slightly
differently, otherwise you will get:
[FileNumber]=ABC99
and this will prompt for the undeclared parameter named "ABC99".

For text fields you must wrap the value in either single of double quote
marks:

Either
"[FileNumber]='" & Me![FileNumber] & "'"
or

"[FileNumber]=""" & Me![FileNumber] & """"

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi TeeSee

You should execute an OpenForm command similar to the following:

DoCmd.OpenForm "Name of your form", , , "[IDNUM]=" & Me![IDNUM]




I am utilizing Allen Brownes' search form to find a record which
happens as it should. Once found, I now want to double click a field
IDNUM to open up a single form to edit existing data matching that
IDNUM field.
There are no subforms involved. I have read several older posts and I
just don't get it. If there is specific info you require from me to
determine where I'm going wrong please let me know.
Click to expand...
Could someone please explain the process and suggest some code? Thanks-
Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Graham ... A sincere thanks for the reponse. I still have the same
problem as follows. Actual field names!

The field [FileNumber] is the field on frmSearch to be double
clicked.
[ctlFileNumber] is on the form being opened.


Private Sub FileNumber_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmMSDSdataInput", , , "[ctlFileNumber]=" & Me!
[FileNumber]
End Sub

Graham .. This is what I don't understand. I believe I have the syntax
correct as you described buy I still get a "Enter Parameter Value" box
looking for a value for [ctlFileNumber]
In the DoCmd line what I would like to understand is .... The position
of the first fieldname (in this case [ctlFileNumber]) is on the form
being opened and the second (Me![FileNumber]) refers to in my case the
search from which is the currently opened form.

Do I have this correct?
Why do you think I am getting the Enter Parameter Value
request.ingsterm
 
Hi TeeSee

Is "ctlFileNumber" the name of a field in the recordsource of
frmMSDSdataInput, or is it just the name of a control on that form?

It should be the name of a field in the recordsource.

If you have, for example, a textbox named ctlFileNumber and it has as its
controlsource a field named FileNumber, then your OpenForm where condition
should be:
    "[FileNumber]=" & Me![FileNumber]

The [FileNumber] on the left is the name of the field in the recordsource of
the form you are opening and the one on the right is the name of the textbox
on the current form (frmSearch).

It will take the *value* in the textbox and append it to the "[FileNumber]="
string to give:
    [FileNumber]=12345

Also note that if [FileNumber] is a text field you need to do it slightly
differently, otherwise you will get:
    [FileNumber]=ABC99
and this will prompt for the undeclared parameter named "ABC99".

For text fields you must wrap the value in either single of double quote
marks:

Either
    "[FileNumber]='" & Me![FileNumber] & "'"
or

    "[FileNumber]=""" & Me![FileNumber] & """"

--
Good Luck  :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


Hi TeeSee
Click to expand...
You should execute an OpenForm command similar to the following:
Click to expand...
DoCmd.OpenForm "Name of your form", , , "[IDNUM]=" & Me![IDNUM]
Click to expand...
- Show quoted text -
Click to expand...

Graham ... A sincere thanks for the reponse. I still have the same
problem as follows. Actual field names!

The field [FileNumber] is the field on frmSearch to be double
clicked.
[ctlFileNumber] is on the form being opened.

Private Sub FileNumber_DblClick(Cancel As Integer)
    DoCmd.OpenForm "frmMSDSdataInput", , , "[ctlFileNumber]=" & Me!
[FileNumber]
End Sub

Graham .. This is what I don't understand. I believe I have the syntax
correct as you described buy I still get a "Enter Parameter Value" box
looking for a value for [ctlFileNumber]
In the DoCmd line what I would like to understand is .... The position
of the first fieldname (in this case [ctlFileNumber]) is on the form
being opened and the second (Me![FileNumber]) refers to in my case the
search from which is the currently opened form.

Do I have this correct?
Why do you think I am getting the Enter Parameter Value
request.ingsterm- Hide quoted text -

- Show quoted text -
Click to expand...

Graham ... Many thanks for going to that extent to explain this for
me. ctlFileNumber was indeed the name of the control. Works like a
charm. Thanks again.
 
Hi TeeSee

You're welcome. Thanks for the feedback.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

On Jun 4, 5:06 pm, "Graham Mandeno" <[email protected]>
wrote:

Graham ... Many thanks for going to that extent to explain this for
me. ctlFileNumber was indeed the name of the control. Works like a
charm. Thanks again.
 
Back
Top