Setting Form Rowsource

  • Thread starter Thread starter gator
  • Start date Start date
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?
 
Forms!frmDeposits1.RecordSource = "SELECT Deposits.DateDep, Deposits.Amount
FROM Deposits"
 
Back
Top