A
Aldred@office
Hi Access Gurus.
I would like to develop something like this:
A continuous mainform which is controlled by some input boxes was created.
I had a button to display the details on that partically transation. This
is the example:
Form A
PO# Part# Quantity Delivered DueDate
4729 06565 20000 9000 9/18/2009
4729 07284 14000 10000 9/18/2009
When I click say the one with part# 06565, then Access Popup a subform with
these
Form B
Part# Delivery# DeliveredQuantity DeliveryDate
06565 1999 5000 9/13/2009
06565 2019 4000 9/17/2009
I need two operations here:
1) Add another delivery transaction to the Form for example
2) Edit the current records in case of something wierd happening.
My strategie was that I create a main continuous form and display Form A's
records. A button will be made, when press that, I have a command to open
the subform:
DoCmd.OpenForm strForm, acNormal, , " PartNum='" & Me!PartNum & "' And
POinNum='" & Forms!fHome!POinNumDelivered & "'", , acDialog
Here comes the problems.
For the Form B, if I use continuous form, I cannot create a button say
add/edit then popup another subform for me to process. Moreover, I found no
way to populate the data I wanted from SubForm B then transfer them to the
new subform. The DoCmd.OpenForm only could transfer the Where clause which
I couldn't fetch them in the form for processing.
A ListBox will also work in displaying the records in form B, however, the
DoCmd.OpenForm from Form A where clause cannot transfer to SubForm B. So,
SubForm B's list box will just display all the records without filtering the
Part# and PO#.
Can some one please point me out about what could I do in such a case?
Thanks.
I would like to develop something like this:
A continuous mainform which is controlled by some input boxes was created.
I had a button to display the details on that partically transation. This
is the example:
Form A
PO# Part# Quantity Delivered DueDate
4729 06565 20000 9000 9/18/2009
4729 07284 14000 10000 9/18/2009
When I click say the one with part# 06565, then Access Popup a subform with
these
Form B
Part# Delivery# DeliveredQuantity DeliveryDate
06565 1999 5000 9/13/2009
06565 2019 4000 9/17/2009
I need two operations here:
1) Add another delivery transaction to the Form for example
2) Edit the current records in case of something wierd happening.
My strategie was that I create a main continuous form and display Form A's
records. A button will be made, when press that, I have a command to open
the subform:
DoCmd.OpenForm strForm, acNormal, , " PartNum='" & Me!PartNum & "' And
POinNum='" & Forms!fHome!POinNumDelivered & "'", , acDialog
Here comes the problems.
For the Form B, if I use continuous form, I cannot create a button say
add/edit then popup another subform for me to process. Moreover, I found no
way to populate the data I wanted from SubForm B then transfer them to the
new subform. The DoCmd.OpenForm only could transfer the Where clause which
I couldn't fetch them in the form for processing.
A ListBox will also work in displaying the records in form B, however, the
DoCmd.OpenForm from Form A where clause cannot transfer to SubForm B. So,
SubForm B's list box will just display all the records without filtering the
Part# and PO#.
Can some one please point me out about what could I do in such a case?
Thanks.