What I am doing wrong?

[qwerty]

I am trying to practice, and typing this in Visual Basic

Private Sub List19_BeforeUpdate(Cancel As Integer)


SELECT * FROM FormQuery
End Sub

I receive an error message stating "Compile Error: Expected: Case"

[ssanfu]

Explain what you are trying to do. More info is needed.

Just having an SQL statement (SELECT * FROM FormQuery) in a procedure will do nothing.

[qwerty]

Explain what you are trying to do. More info is needed.

Just having an SQL statement (SELECT * FROM FormQuery) in a procedure will do nothing.

I am practicing retrieving data from a query I created. I am trying to start with basics https://www.w3schools.com/sql/. I wrote it exactly that. My record source is already setup in the form. I am trying to get a field to appear in the listbox and filter base on the selection made in the first page. I can post the file online, but welling to pay someone on here to view my computer screen through Skype and teach me. Let me know your price?

[ssanfu]

OK, you have a bound form with a list box on it. You would set the List box Control Source property to a field in the form record source. Then you would need to set the List box Row Source property to a Saved Query or an SQL statement.

<snip> and filter base on the selection made in the first page.

Not sure what you mean by this -what is "in the first page"?



Yes, it would help if you posted your dB.

[qwerty]

OK, you have a bound form with a list box on it. You would set the List box Control Source property to a field in the form record source. Then you would need to set the List box Row Source property to a Saved Query or an SQL statement.



Not sure what you mean by this -what is "in the first page"?



Yes, it would help if you posted your dB.

Do you have Skype? I will screen share and pay you?

[ssanfu]

Sorry, I don't have Skype.

I would strongly suggest working through the tutorials from RogersAccessLibrary to get familiar with the process. Don't just look at them, actually take the time to do them.

Still willing to post your dB?