Open new form to display chosen data 1

[BradCollins]

After days of trying, I admit defeat and would like the help of all the kind souls here.

My problem is I am trying to open a form (form 2) and display the data chosen from the first form

so far I have :

   Dim strReturnFormName As String
   Dim StrCallNo as String

   strReturnFormName = "Form 2"
   strCallNo = Me.txtCallNo.Value

   If me.txtField.Value = "" Then
       Msgbox "You must enter data." & Chr(13) & _
              "You will now be returned to do this"
       DoCmd.Close
       DoCmd.OpenForm strReturnFormName, acNormal, , "[fldIssueID]=" & strCallNo
        
    EndIf

no matter what i try, it closes Form 1 without a problem and opens Form 2 as it should, but displays ready for a new entry, not the details of the chosen record.

I have tried (for days) now to play with the selection critera and have tried :
"[fldIssueID]=" & strCallNo
"[fldIssueID] = " & strCallNo
"[fldIssueID]=" & "'" & strCallNo & "'"
"[fldIssueID] = '" & strCallNo & "'"

and a few other combinations, but it just wont work. Can anyone point out where I have gone wrong here.

Thanks

 

[fneily]

Let's see, Me.txtCallNo.Value is on Form1. You Dim a variable for Form1. You then close Form1. Then open Form2 trying to use a control which is saved in a variable on Form1 which is closed. Can't do this. When you refer to a control on another form, that form must be opened. Try it without closing Form1.
Also, the ususal way to refer to a control on another form is by Forms![Formname]![ControlName]
The word Forms is known as a container. It contains all open form names.
Formname is obviously which open form you want to refer.
And then which control on that form.

 

[scottian]

I would create a query and set the criteria for whichever field links the two forms to match whatever is on the first form. then_

whatever event triggers the opening of form2

If me.myField.Value = "" Then
do nothing
else
DoCmd.OpenForm "Form2"
DoCmd.Close "Form1"
EndIf

And i think you need to set the "Allow Additions" property of form2 to 'no'.

Unless im missing something



"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[BradCollins]

closing the form doesnt seem to matter, as I have already set the variable value in the code.

to check this is true
I added 3 checks by including the code

Msgbox strCallNo & " - Break 1"

before the DoCmd.close and

Msgbox strCallNo & " - Break 2"

after it and then

Msgbox strCallNo & " - Break 3"

after the DoCmd.OpenForm, that way I could be sure that the string strCallNo is still valid at each point, and it is

behind the messages, Form 1 closes and Form 2 Opens, but still not opening to the selected record

 

[bubba100]

What happens if you place Msgbox strCallNo & " - Break 3" in the OnOpen event of Form 2?

 

[BradCollins]

That wouldnt work would it, as the variable is not valid for use in the onopen event of Form 2, I am using it in the WHERE clause of the openform event that is run from Form 1 and it is valid there.

 

[bubba100]

Then maybe- strCallNo -is not getting passed to form2.

 

[BradCollins]

but if you are using it in the WHERE clause I didnt think it need to be, just so long as it was available for use in the WHERE clause.

Of course it wouldnt be the first time I have been wrong

 

[bubba100]

Straight from the help in my old Access97
DoCmd.OpenForm "Employees", , ,"LastName = 'King'"


From your first post. There appears to be a difference. Plus when you step throught the code hoover over the last section to see what it reads, is it similar to the above.

DoCmd.OpenForm strReturnFormName, acNormal, , "[fldIssueID]=" & strCallNo

 

[PHV]

but displays ready for a new entry
What is the value of the DataEntry property of form 2?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BradCollins]

A star for you PHV

thank you, my code was correct in the begining, it was the form settings on Form 2 that were stopping it.

Problem now fixed.

Thank you once again