Saving data that is linked from other form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EMILYTAN - 03 May 2007 08:46 GMT

can i ask u another question?
I have a form with ItemID and another form with ItemID too. This means this 2
forms are linked based on the ItemID. So, when i want to add record in the
second form, i need to type in the itemID again although it is under the same
category. So, to make it easier, I put the ItemID linked from the first form
and under the control source, i put =Forms!Item!ItemID and it really works..
However, when I want to save the record, all the other item can be saved
except that particular ItemID that is being linked from the first form.
May I know how to save the data in? Or perhaps any other idea?

Reply to this Message

AccessVandal - 03 May 2007 11:08 GMT

Hi Emily,

There are very little information on what really you want to do.
What i can guess is you really want is a combobox?

>can i ask u another question?
>I have a form with ItemID and another form with ItemID too. This means this 2
[quoted text clipped - 5 lines]
>except that particular ItemID that is being linked from the first form.
>May I know how to save the data in? Or perhaps any other idea?

Reply to this Message