why no body reply this question ?
It appears to me that you asked the question at 16:25 hours and posted this
followup at 17:44 hours on the same day. There can be a number of reasons
that there is no reply to a question, but first we should establish that no
one is obligated to answer any question in these newsgroups, and no one here
is paid to answer the questions -- that is, this is not just a means to
contact Microsoft Technical Support. All answers come from volunteers and
whether you get an answer and, if so, how soon, can depend on a number of
factors:
(1) A primary reason is that it might have been a busy time of day for
people answering questions and no one had the time to answer that particular
one
(2) Everyone who looked at it was puzzled by the question, but did not have
the time, energy, or interest to follow up asking you for specific
clarification
(3) No one answering questions during that time period felt qualified to
answer, or had an interest in answering, a question on the subject.
(4) No one had an answer for it, but rather than post to say, "I don't have
an answer," they just did not answer and hoped that, sooner or later,
someone else would have.
or one of many other reasons.
Patience, they tell me, is a virtue. If you have more money than patience,
you can always call technical support and pay.
In my case, I didn't see your question until after you'd asked why no one
had answered, and I didn't quite understand what you described...
Particularly, I don't know what you are asking by "after updating, go and
open issue table, except item name are updated. how could we update item
name."
Are you truly keeping Item Name both in the Item Table and in the Issue
Table, when you could/can Join the Tables in a Query and avoid having
redundant data? I would advise against keeping redundant data, but if that
is what you are doing, then you need to include both Item No and Item Name
in the RowSource of the ComboBox, and have a Text Box (whose visible
property can be "No" if you desire) bound to the Item Name field of the
Issues Table. Set the Text Box, in the After Update event of the Combo to:
Me.txtItemName = Me.cboSelectItem.Column(1)
where you replace "textItemName" with the name of the bound Text Box for
Item Name, and "cboSelectItem" with the name of your Combo Box used to
select the Item.
Larry Linson
Microsoft Access MVP
for information about the MVP program and MVP's, see
http://mvp.support.microsoft.com