Set combo rowsource on form open event (97)

Topic

New Reply

Set combo rowsource on form open event
Unless I

Reply | Quote

Replies

What data type is code? If it’s text you don’t need the ampersands. If it’s a number you don’t need the single quotes.

Reply | Quote

Code is number data type, and thanks! I just solved part of the problem as I was running an old function before the new SELECT CASE statements I entered. Now I

Reply | Quote

If code is a number then your sql string should look like this:

strSQL = “SELECT [Code],[Description] FROM Budget WHERE [Code] = 0160250 Or [Code] = 140360249;'”

Reply | Quote