Referes to VB 6.0
I have create a database file called "ar.mdb" and in the "ar.mdb" i have create several table called "code", "CCategory" and etc.
How can I access various tables in a database file to a form.
Below coding will occur run time error. Do you know the coding.
Private Sub Form_Load()
SQL = "SELECT * FROM CCategory ORDER BY CusCat"
SQL = SQL & "SELECT * FROM SCategory ORDER BY SalesCat"
SQL = SQL & "SELECT * FROM Code ORDER BY CardCode"
Set RS = gDB.OpenRecordset(SQL)