Form as a front-end?

M

Milind

Dear Mr Wayne
Thanks for the detailed reply. Could you tell me one more thing? For data
entry, you are recommending a form (that is what I gather from the reply)
which can have a lookup entry to provide the list of items that a field
TypeID represents! If that is so, I wonder why all the (Gurus) who write
books don't specifically underline this safeguard? In most books, each
details the steps which I was following. [Though now I understand, but the
learning graph has become steep.]
Regards
 
S

Scott McDaniel

Dear Mr Wayne
Thanks for the detailed reply. Could you tell me one more thing? For data
entry, you are recommending a form (that is what I gather from the reply)
which can have a lookup entry to provide the list of items that a field
TypeID represents! If that is so, I wonder why all the (Gurus) who write
books don't specifically underline this safeguard? In most books, each
details the steps which I was following. [Though now I understand, but the
learning graph has become steep.]
Regards
Click to expand...

I believe Wayne was basically telling you to use a Combo or Listbox, with the Bound column set to the column you wish
stored in your database, and with other columns showing more descriptive information about the record. YOu can
accomplish this by setting the various .ColumnWidths to show/hide columns (a ColumnWidth of 0 will hide a column). All
the Gurus who write books DO advocate this method when using combos and listboxes, if that's what you're referring to.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
L

Larry Linson

Milind said:
Dear Mr Wayne
Thanks for the detailed reply. Could you tell me one more thing? For data
entry, you are recommending a form (that is what I gather from the reply)
which can have a lookup entry to provide the list of items that a field
TypeID represents! If that is so, I wonder why all the (Gurus) who write
books don't specifically underline this safeguard? In most books, each
details the steps which I was following. [Though now I understand, but the
learning graph has become steep.]
Regards
Click to expand...

It is difficult enough to follow newsgroup discussions when they are posted
as followups to a thread of previous posts on the subject, and with enough
quoted material to establish context... with hundreds of posts every day in
this newsgroup, it's unlikely that many will make the connection between
this and the previous discussion. For other good suggestions on effective
use of newsgroups, see the Frequently Asked Questions (FAQ) at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
 
Top