Terry Kreft wrote:
Quote:
You should not open tables.
This is bogus advice, I think.
You should open tables if you need to or if you want to. There's certainly
no need to create a form and report for every table in your system, eg just
to edit a small lookup table (or even a large transaction table).
Especially if you "know" your data.
Quote:
You should use a form for data entry and a report for data review.
Why? Though a well-defined form can give you more control and safety, it's
no panacea, and building good validation rules and proper data typing can
aid in entering data directly in tables.
Quote:
Either way, you use a query as the recordsource as you can then sort
the data in any way you want.
Yes. Or you can filter and sort it pretty much any way you want if you open
the table directly.
Quote:
"Troy" <TroyDDaniels@gmail.comwrote in message
news:1153171240.846503.122570@b28g2000cwb.googlegr oups.com...
Quote:
>Public Sub test()
>>
>DoCmd.OpenTable ("OSM Table 1")
>>
>End Sub
>>
>Amazingly, I've gotten this far, now I am wondering how to sort the
>database in ascending order according to field called [Meal Total]
>and then select the first record. It's all got to be in VBA, can
>anyone help?
>>
>Thanks