Double Click to Open Form

T

TeeSee

Please help!
I have a Form/Subform[frmMainList] and [SfrmItemsListSUB]. The Form
has an unbound text bo used for lookup. The record source is as
follows.
SELECT DISTINCT tblMaterialMaster.LocalGroup FROM tblMaterialMaster;

Two of the fields on the subform are [LocalGroup] and LocalSubGroup]

The following lines open form [frmCustomerDiscountsPU]
Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "frmCustomerDiscountsPU", acNormal, , , acFormEdit
Forms![frmCustomerDiscountsPU]!MaterialSubGroup.Value = Forms!
[frmMainList]![SfrmItemsListSUB].Form![LocalSubGroup]
End Sub

If I understand this correctly the record source line does nothing
other than populate the unbound text box and the child parent link
brings the matching data into the subform. Why then can I not get the
[frmCustomerDiscountsPU] to show only the data that pertains to the
subgroup fields?

Please critique and suggest. Hope I have supplied enough info! Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Open Form with Current Record 7
selecting a record from continuous form 3
double click event to open form where 3
On Click Event 2
Modify Code on Form 2
how to double click a list box item to add to subform 6
Trying to Open subform on click event to current record from main form 2

Top