If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form linking
I have a form in which I have a list box (lookup table)in
the header and depending on the choice, I would like to display records from another table. I am unable to accomplish this. Could anyone help. I know this is very basic..but I seem not to find much help. Thanks |
#2
|
|||
|
|||
The code below calls a form to receive items ordered on a PO where the PO
line items already exhist but the quantities to be received and prices need to be entered. This should help. Private Sub QtyRec_Click() Dim desc As String If Qty 0 Then stDocName = "purchaseReceipts" stLinkCriteria = "[purchid]=" & Me![PurchId] & " and " & "[DeviceId]= " & Me![DeviceId] & " and " & "[Description]= '" & Me.Description & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Else: MsgBox "There is nothing to be received" End If End Sub " wrote: I have a form in which I have a list box (lookup table)in the header and depending on the choice, I would like to display records from another table. I am unable to accomplish this. Could anyone help. I know this is very basic..but I seem not to find much help. Thanks |
#3
|
|||
|
|||
I am sorry but i do not understand. Let me show you what
I am doing. I really appreciate the help because I have been struggling with this since yesterday. I have tables Department and AssignCostCenter. In the form i create, the DepartmentName (only field in Department) is a list box in the header. Depending on the value of the DepartmentName (eg. Accounting), I would like the Detail to list all the Cost centers in Accounting (AssignCostCenter table has only DepartmentName and Cost Center-many to many relationship if you consider that Manufacturing will also have the same Cost Centers). I have tried a single form, form/subform...something or the other is not working.Any help is much appreciated. Thankyou. -----Original Message----- The code below calls a form to receive items ordered on a PO where the PO line items already exhist but the quantities to be received and prices need to be entered. This should help. Private Sub QtyRec_Click() Dim desc As String If Qty 0 Then stDocName = "purchaseReceipts" stLinkCriteria = "[purchid]=" & Me![PurchId] & " and " & "[DeviceId]= " & Me![DeviceId] & " and " & "[Description]= '" & Me.Description & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Else: MsgBox "There is nothing to be received" End If End Sub " wrote: I have a form in which I have a list box (lookup table) in the header and depending on the choice, I would like to display records from another table. I am unable to accomplish this. Could anyone help. I know this is very basic..but I seem not to find much help. Thanks . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Edit PivotTable Form | Manuel | Using Forms | 0 | August 24th, 2004 11:29 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Modal form | Praveen Manne | Using Forms | 1 | July 6th, 2004 10:49 PM |
Modal form | Praveen Manne | General Discussion | 1 | July 6th, 2004 10:49 PM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |