Quick & Dirty Table viewing

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

If you open a view of a table using the DoCmd.OpenTable
method is it possible to move to a specific record in the
table that is opened? I cannot figure out how to reference
a table view that is opened in this manner.

I was thinking this would be a quick and dirty way of
popping up a table for the user to browse, but I am
starting to think that building a form to display the
table contents will be easier in the long run.

Any suggestions?
Thanks in advance,

TK
 
Hi.
I was thinking this would be a quick and dirty way of
popping up a table for the user to browse, but I am
starting to think that building a form to display the
table contents will be easier in the long run.
Click to expand...

A properly designed database application doesn't allow users to view the
tables directly. A form is preferable to viewing the raw data in the table,
since the form can validate the data inputs, events can be controlled and
customized, and records can be sorted, filtered, automatically scrolled to,
et cetera.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top