Setting Form Rowsource

G

gator

I understand how to set a rowsource for a listbox or combobox.

lstBox1.RowSource = "SELECT Deposits.DateDep, Deposits.Amount FROM Deposits"

But how do I set the rowsource for a tabular form? What do I put in place
of lstBox1...assuming the form name is frmDeposits1?
 
D

Douglas J. Steele

Forms!frmDeposits1.RecordSource = "SELECT Deposits.DateDep, Deposits.Amount
FROM Deposits"
 
L

Linq Adams via AccessMonster.com

And take note from Doug's example that a form does not have a "RowSource," it
has a ***RecordSource.***

Only Comboboxes and Listboxes have RowSources.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top