Calling up another form - Not Working

[Buakaw]

Hi,


I'm trying to call up a particular record in another form from the current form I'm on. I've tried different options for several days but it's still not working.

The main form is frmPaymentSelectName. This form will list out the names of all students. When I click the "Pay" button on the side of the name, I want it to bring up the correct record in frmPaymentDetails.

I'm encountering several problems currently.

1) The "Pay" button will call ClickToPay_Click() when pressed. I have declared a temp dbgString, which I put on the watch window, to see what gets passed in.

No matter which button I press (under the 3 different names), the name that's always sent in is "Rajah Gopal". If I press Chuck Smith's button, it will still send in "Rajah Gopal". Why is this happening?

2) I'm trying to open the right record in frmPaymentDetails, by setting up the whereString. However, it is not working.

I get a box prompting me to "Enter Parameter Value". Why does this happen?

If I enter "Chuck" for example, I still get a blank frmPaymentDetails form.

Ideal) What I want to happen is, when I press the button in frmPaymentSelectName for Chuck Smith for example, it brings me to Chuck Smith's record in frmPaymentDetails.

Help anyone? Thanks.

[jzwp11]

You're code was not quite correct. The field names in the table have a space [First Name], but your code did not. I also included both the first and last names in the string. The corrected code is as follows

    whereString = "[First Name] = " & "'" & Me.FirstName & "' AND [Last Name]='" & Me.LastName & "'"
    DoCmd.OpenForm "frmPaymentDetails", , , whereString, acFormEdit

When you open the form, the first record will always have the focus, so to open the frmPaymentDetails form for another person, you must click in the name control for the person (this changes the focus) and then click their pay button.

[Buakaw]

You're code was not quite correct. The field names in the table have a space [First Name], but your code did not. I also included both the first and last names in the string. The corrected code is as follows

    whereString = "[First Name] = " & "'" & Me.FirstName & "' AND [Last Name]='" & Me.LastName & "'"
    DoCmd.OpenForm "frmPaymentDetails", , , whereString, acFormEdit

When you open the form, the first record will always have the focus, so to open the frmPaymentDetails form for another person, you must click in the name control for the person (this changes the focus) and then click their pay button.

Thank you very much!

There is something I don't understand. When I go to Design View in frmPaymentDetails, and I click on the PropertySheet for the [First Name] and [Last Name] fields, I go to the "All" tab and I see that the Name of the control does not have a space in between.

The value of "control source" has a space (i.e. [First Name]) but the value of the "Name" of the control is actually [FirstName]), without the space.

So I don't understand why the code with the space works?

An additional quesiton: Is there a way for me to add code so that the user does not need to click on the name before clicking on the button?

One simple idea is to just do away with the button and make the user double click the name.

But if I wanted to keep the "button", is there a way for me to change the focus to the record clicked *after* he has clicked the button? I have no idea how to know which button he clicked from inside the code.

Thanks!

[jzwp11]

I don't usually use continuous forms that much, so I don't know of a way to change the focus other than clicking in one of the other controls. What I would do in this case is use a combo box that has the names and then when the name is selected in the combo box, open the other form. I have used your same query to populate the combo box in the attached database; please see form frmPaymentSelectName2.

[Buakaw]

Thank you so much!

Btw, do you have any idea why this is so?

There is something I don't understand. When I go to Design View in frmPaymentDetails, and I click on the PropertySheet for the [First Name] and [Last Name] fields, I go to the "All" tab and I see that the Name of the control does not have a space in between.

The value of "control source" has a space (i.e. [First Name]) but the value of the "Name" of the control is actually [FirstName]), without the space.

So I don't understand why the code with the space works?

Thanks!

[jzwp11]

The control source is the actual field name in your table or query. In both your tblMainStudentInfo and in the query that you use for the form, the first and last name fields have a space in them, so that is why the control source has a space in it. In queries, you can assign alias names to those field names, the alias name would then become the control source if you bound this query to a form

SELECT tblMainStudentInfo.[First Name] as StudentFirstName etc.
FROM tblMainStudentInfo

If you use the form wizard or do a drag and drop of field names onto a form in design view, Access generally names the control the same as the field name of the table or query. Of course, you can change the control name, so why your controls are not the same as the field name suggests to me that they were changed at some point.

Now as to the code statement below, the items shown in red are the FIELD names of the table or query while the items shown in blue are the FORM CONTROL NAMES that are supplying the data that will be used for the criteria based on the FIELD names indicated.

whereString = "[First Name] = " & "'" & Me.FirstName & "' AND [Last Name]='" & Me.LastName & "'"

[Buakaw]

The control source is the actual field name in your table or query. In both your tblMainStudentInfo and in the query that you use for the form, the first and last name fields have a space in them, so that is why the control source has a space in it. In queries, you can assign alias names to those field names, the alias name would then become the control source if you bound this query to a form

SELECT tblMainStudentInfo.[First Name] as StudentFirstName etc.
FROM tblMainStudentInfo

If you use the form wizard or do a drag and drop of field names onto a form in design view, Access generally names the control the same as the field name of the table or query. Of course, you can change the control name, so why your controls are not the same as the field name suggests to me that they were changed at some point.

Now as to the code statement below, the items shown in red are the FIELD names of the table or query while the items shown in blue are the FORM CONTROL NAMES that are supplying the data that will be used for the criteria based on the FIELD names indicated.

whereString = "[First Name] = " & "'" & Me.FirstName & "' AND [Last Name]='" & Me.LastName & "'"

Thank you very much!

[jzwp11]

You're welcome. Good luck with your project.