FireStrike
Registered User.
- Local time
- Yesterday, 21:44
- Joined
- Jul 14, 2006
- Messages
- 69
Hello,
I have a table called tbl2A. I want to open this table as long as there is some data in it. I have the code below that works very well.
The question I have is if there is a cleaner, more elegant way of doing this. I actually have a number of tables, and this ends up being alot of code for each of them.
Thank you in advance.
I have a table called tbl2A. I want to open this table as long as there is some data in it. I have the code below that works very well.
Code:
strSQL = "select * from tbl2A"
Set rcd = CurrentDb.OpenRecordset(strSQL)
rcd.MoveFirst
If rcd.RecordCount > 0 Then
DoCmd.OpenTable "tbl2A"
End If
The question I have is if there is a cleaner, more elegant way of doing this. I actually have a number of tables, and this ends up being alot of code for each of them.
Thank you in advance.