problem with showing lists from multiple tables

[wshm]

Im trying to show lists of ('bfsix', 'buddesc', 'rvname', balan', 'bfsix') fields. where rvname is from tbl_Revenue versus others from tbl_BudMaster.
user will be able to choose a bMonitor and the list is suppose to show recall information based on that selection.
for some reason, I am getting a blank list page.
It seems like it works fine if I remove the RvName.
Is it not possible to show lists of fields from different table?
below is the coding..

SELECT tbl_BudMaster.Bmonitor, tbl_BudMaster.AbID, tbl_BudMaster.BudDesc, tbl_Revenue.RvName, tbl_BudMaster.Balan, tbl_BudMaster.Bfsix
FROM (tbl_Bmonitor INNER JOIN tbl_BudMaster ON tbl_Bmonitor.Bmonitor = tbl_BudMaster.Bmonitor) INNER JOIN tbl_Revenue ON tbl_BudMaster.RevNum = tbl_Revenue.RevNum
WHERE (((tbl_BudMaster.Bmonitor)=[forms]![frm_BudgetUpdate]![cboBmonitor]));

 

[dhookom]

You should attempt to use some basic Access terms like tables, fields, records,... You used "information", "blank list page", "lists", ... with out providing information about your tables, fields, etc. Why you think your sql should work? Does the SQL display records if you replace the form control reference with a legitimate value or remove the "where" clause entirely?

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]

 

[wshm]

i guess what im asking is..
can a "listbox" display multiple fields from multiple tables?
ie. field1 from Table1 and fieldA from TableA.
maybe the listbox should look like

| field1 | fieldA |
| a | name |

 

[dhookom]

A list box can list anything you want. Generally we create list boxes with a Row Source Type of a Table/Query. You can use any query or SQL you want for this since queries can be based on multiple tables/queries.

You can also use code to populate the Row Source of a Value List list box.

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]