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"
 

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

Similar Threads

Help with Currency Format 3
trying to get Filter on Subform to work with Multiselect in Listbo 2
Cascading Comboxes 2
Control1 GotFocus and Control5 RowSource 5
Form name in variable 3
Referring to form field in control's RowSource WHERE clause 5
SELECT FROM Query name 1
Can I Open a list box at a Specific Location on Form? 1

Top