Form in a Form Query from Textbox

[bahalzamon]

Hello Geniuses!



I have a form within a navigation form and am attempting to pull the information within a text box to re-query the information for a listbox.
The part I am having issue with is:

WHERE [queryStudentStatus].[SSID] = Forms!formNavigation!formStudentHistory.Form!Student;

When I run the exact same code from within "formStudentHistory" it works perfectly when I change it to:

WHERE [queryStudentStatus].[SSID] = Forms!formStudentHistory!Student;

I retrieved the info on how to do the code from here. But I must be doing something wrong and i'm sure its going to be something simple I am missing. =)

The whole button code

Private Sub btnRefresh_Click()
    If IsNull(Me.Student) Then
        List28.RowSource = "SELECT [queryStudentStatus].[SSID], [queryStudentStatus].[firstName], [queryStudentStatus].[lastName], [queryStudentStatus].[Barcode], [queryStudentStatus].[Manufacturer], format([queryStudentStatus].[checkOut],'Short Date'), format([queryStudentStatus].[checkIn],'Short Date') FROM [queryStudentStatus];"
        List28.Requery
    Else
        List28.RowSource = "SELECT [queryStudentStatus].[SSID], [queryStudentStatus].[firstName], [queryStudentStatus].[lastName], [queryStudentStatus].[Barcode], [queryStudentStatus].[Manufacturer], format([queryStudentStatus].[checkOut],'Short Date'), format([queryStudentStatus].[checkIn],'Short Date') FROM [queryStudentStatus] WHERE [queryStudentStatus].[SSID] = Forms!formNavigation!formStudentHistory.Form!Student;"
        List28.Requery
    End If
End Sub

Please and assistance would be greatly appreciated, also if you need any additional info from me please let me know. =D

[ssanfu]

I do not use the navigation form, so I have no experience with it. But I did find a site that might help:

Navigation Control - Subforms
http://bytes.com/topic/access/answer...ntrol-subforms

[bahalzamon]

Thanks ssanfu,

It didnt get me the answer directly, but it got me looking in the correct location and by doing a bit of winging it, I got it to work. =)
Thanks for the help.

This is what worked for me:

WHERE [queryStudentStatus].[SSID] = [Forms]![formNavigation]![NavigationSubform].[Form]![Student]

My problem was with it saying [NavigationSubform] I thought it was refering to the form within the navigation form of [formStudentHistory] in my case, but [NavigationSubform] is the default name of the object when selecting it in design view. That is how I got to the correct answer. =)


The Breakdown how I saw it
Code = [Forms]![formNavigation]![NavigationSubform].[Form]![Student]
[Forms] = constant as pointing to the forms section of your Access file
[formNavigation] = the name of your navigation form, for me it was formNavigation
[NavigationSubform] = the name of the object within your navigation for, found within the properties > Other > Name, this navigates it to the correct location
[Form] = I think saying you are looking at a form to access the proper objects within it
[Student] = the object you are attempting to access, for me its a text box used to requery the data within a list box

[ssanfu]

Excellent..

IMO, the navigation form is too restrictive, so I create my own navigational forms. But I'm glad it worked out for you.

[bahalzamon]

Well, this is my first use of Access, I would love to do some more cool stuff, but this is at about the extent of what I know/dont know...lol
Thanks again for the help. =D

-bahalzamon