JackMack
Last Activity: Feb 15 '13, 12:04 AM
Joined: Feb 8 '13
Location:
-
No. I didn't. But after reading your note, I tried that and sure enuf, there it is. Thx for the tip. -
My Visual Basic for Access does not seem to have a compile option. but I created the button as you suggested and it DID IN FACT open the second form. And it used the WeekNmbr value to select only those rows that matched. Thank you all so much for your help. Should I leave well enough alone, or should I continue my efforts to make clicking on a row open the second form?
Have any of you ever made a form that displayed the rows from a...Leave a comment:
-
I am clicking on one of the rows displayed in the form.
Seth, Thx for the reply. At this point, I'd be happy to just be able to get the second form to open by clicking in the first form.Last edited by NeoPa; Feb 14 '13, 06:43 PM. Reason: You don't need to put every sentence in a separate post.Leave a comment:
-
Yes. And procedure is set to:
...Code:Private Sub Form_Click() DoCmd.OpenForm "All_Matches_Frm", , , "WeekNmbr = Me.WeekNmbr", , , "Me.WeekNmbr" End Sub
Leave a comment:
-
I created two forms. In the first form, I added
to the "On Click" property. However, it does NOT open the second Form. There is no error produced. It just seems to ignore the click. Anyone got any ideas?Code:Private Sub Form_Click() DoCmd.OpenForm "All_Matches_Frm", , , , , , Me.WeekNmbr End Sub
Leave a comment:
-
Get Correct Value
Form1 is bound to a table with two columns: Week_Number, Week_Date. Work_Number column has numbers 1 though 52. Week_Date has the date of each Saturday in the year. When a user clicks on a row, I want that "Click" to open Form2 and pass the Week_Number value to Form_2.
Form_2 has three columns: Week_Number, Home_Team_ID, and Away_Team_ID. When it opens, I want the "cursor" to be on the first row that corresponds...
No activity results to display
Leave a comment: