Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Access 2013: Perform action when a drop-down list item is selected in a form
Hello. I have a drop down list with some items in a form and I want when one of these items is selected, an action to be performed.
To be more specific, there is a list of dates that a person visited my office. When I select a date, I want a subform to open with the details of this (and only this) visit. If a select another date, I want to see the details of this other date.
How easy is this to be performed?
Any help will be appreciated.
Thanks for looking.
To be more specific, there is a list of dates that a person visited my office. When I select a date, I want a subform to open with the details of this (and only this) visit. If a select another date, I want to see the details of this other date.
How easy is this to be performed?
Any help will be appreciated.
Thanks for looking.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In the AfterUpdate event of the control, you would use the date from the control and the current visit PK as part of the WHERE argument for the open form:
Here's an example of constructing the WHERE argument first as as string, then opening a pop-up form to display data:
strWhere = "[InvoiceDate] = #" & Me.txtInvoiceDate & "# AND [CustID] = " & Me.cboCustID
DoCmd.OpenForm "frmDuplicates", acNormal, , strWhere, acFormReadOnly, acDialog
Jim.
Here's an example of constructing the WHERE argument first as as string, then opening a pop-up form to display data:
strWhere = "[InvoiceDate] = #" & Me.txtInvoiceDate & "# AND [CustID] = " & Me.cboCustID
DoCmd.OpenForm "frmDuplicates", acNormal, , strWhere, acFormReadOnly, acDialog
Jim.
You can use the AfterUpdate event of the combobox to open a form
Private Sub ComboBox_AfterUpdate()
docmd.OpenForm formName:="MyForm",Wherecondition:="DateEntered=#" & me.combobox & "#"
end sub
@Jim Dettman:
Used this code
Private Sub AptDateBox_AfterUpdate()
strWhere = "[AptDate] = #" & Me.AptDateBox & "# AND [Ptn_ID] = " & Me.cboPtn_ID
DoCmd.OpenForm "Frm_Ptns_Dates_Exams_Echo
End Sub
where AptDateBox is the combo box caption, AptDate the name of the field in the table, txtAptDate is the name of the combo box Label and Ptn_ID the ID of the person.
I get an error for Me.txtAptDate : Method or data member not found
Any thoughts?
Used this code
Private Sub AptDateBox_AfterUpdate()
strWhere = "[AptDate] = #" & Me.AptDateBox & "# AND [Ptn_ID] = " & Me.cboPtn_ID
DoCmd.OpenForm "Frm_Ptns_Dates_Exams_Echo
End Sub
where AptDateBox is the combo box caption, AptDate the name of the field in the table, txtAptDate is the name of the combo box Label and Ptn_ID the ID of the person.
I get an error for Me.txtAptDate : Method or data member not found
Any thoughts?
Fixed some things. Now when I select a value from the combo, a pop-up window is asking
Enter paramete value:
AptDate
There, I must write a value visit date in order to continue.
Any ideas?
Enter paramete value:
AptDate
There, I must write a value visit date in order to continue.
Any ideas?
Hello again.
What I have succeeded so far.
The database refers to Patient Visits to my office and data collected in each visit.
The Frm_Ptn_VisitDate enters the Dates a Patient Visits my Office.
In the Frm_Testing I have a Form/Subform Configuration. If I select a Date in Combo17 (AptDate1 Label), it correctly changes the name of the Patient and the data collected in the specified date on the Subform.
1) What I can NOT do, is to have Combo17 show ONLY the dates a certain Patient visited my Office and not all the visits from all the Patients.
2) Another (better?) solution would be to create Cascaded Combo Boxes. For this cause I have added Combo19 from where you can select a Patient Name (I removed the duplicate values). Based on this Combo Box I would like Combo17 to show ONLY the dates this certain Patient visited my Office.
Thanks for your help. Waiting for your feedback.
SO_FAR.accdb
What I have succeeded so far.
The database refers to Patient Visits to my office and data collected in each visit.
The Frm_Ptn_VisitDate enters the Dates a Patient Visits my Office.
In the Frm_Testing I have a Form/Subform Configuration. If I select a Date in Combo17 (AptDate1 Label), it correctly changes the name of the Patient and the data collected in the specified date on the Subform.
1) What I can NOT do, is to have Combo17 show ONLY the dates a certain Patient visited my Office and not all the visits from all the Patients.
2) Another (better?) solution would be to create Cascaded Combo Boxes. For this cause I have added Combo19 from where you can select a Patient Name (I removed the duplicate values). Based on this Combo Box I would like Combo17 to show ONLY the dates this certain Patient visited my Office.
Thanks for your help. Waiting for your feedback.
SO_FAR.accdb
Found my way through it. Show the following video and helped too.
http://www.datapigtechnologies.com/flashfiles/combobox2.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html
Premium Content
You need an Expert Office subscription to comment.Start Free Trial