Get Unrelated Data From Separate Tables

[iisman]

I currently have a page that gets data from one table, and displays th34e info for each item, and loops.

strSQL = "Select * From tblproj WHERE projcategory LIKE " & strShowCat & " AND projstatus Not LIKE 4"

I want to get data from a separate table, to populate a dropdown selection that needs to be displayed for each item.

does anyone know how i can do this?

thanks in advnace for the help

 

[dhookom]

What do you mean by page? Your question suggests you are developing a web application.

If this is truly and Access question, you apparently have a combo box which has a Row Source property. This is generally a table or query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]