NEW ENTRY IN DROP-DOWN

[FARAZ QURESHI]

I have a customer's Payment Mode field in the Transaction Record Table which
offeres selection of either:
Check;
Cash; or
Master Card,

by inserting ROW SOURCE: "Check";"Cash";"Master Card", in the Lookup Tab.

Now, if a customer pays with some other way for example Wire Transfer, how
can I insert such a new entry without maintenance of a totally separate table
or manually entering a new item in the ROW SOURCE?

A site for a sample file would be more obliged

Thanx again!

 

[Wayne-I-M]

SELECT TableName.Items FROM TableName ORDER BY [Items];

Set the limit to list to = No

 

[Dale Fye]

Wayne's method will work, if you are not concerned with keeping control of
what goes in your data fields. But if you want more control (as in to prompt
the user when they enter a value that is not in the list), then use the combo
boxes NotInList event.

If you search this group on NotInList, you will find a variety of code
segments that will help.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.