AccessProgram
Registered User.
- Local time
- Today, 13:14
- Joined
- Dec 7, 2009
- Messages
- 68
Hello guys, I am asking again for your help on my problem.
I have this subform which is on continousformview. On one combobox, you are to input ItemID. One ItemID is related to one AccountingID.
If I have 5 itemid in the subform, when I click the Journal Button, it would suppose to lookup the related accountingid to the itemid and post the accountingid to the combobox in another subform in the same MainForm.
I can use dlookup to look for the value of accountingid where criteria is itemid.
My questions are:
My problem since it involves 5 itemid, how can I use the loop to process the first itemid in the field, then the next itemid and so on.
And how can I post the accountingid on the combobox on the other subform one by one on the same MainForm.
I have this subform which is on continousformview. On one combobox, you are to input ItemID. One ItemID is related to one AccountingID.
If I have 5 itemid in the subform, when I click the Journal Button, it would suppose to lookup the related accountingid to the itemid and post the accountingid to the combobox in another subform in the same MainForm.
I can use dlookup to look for the value of accountingid where criteria is itemid.
My questions are:
My problem since it involves 5 itemid, how can I use the loop to process the first itemid in the field, then the next itemid and so on.
And how can I post the accountingid on the combobox on the other subform one by one on the same MainForm.
