Using Parameters From Fields In Forms

  • Thread starter Thread starter Dazza
  • Start date Start date
D

Dazza

I am new to access projects and need to be able to display data in a listbox
applicable to only the present record on view in the form.

How can I, therefore, pass the parameter (the recordID) to either a view or
stored procedure that the list box uses to display the output?

In normal Access this was simple by setting criteria in a query to look
towards the form and field but this is not the case in a project.

Your advise in this matter is appreciated.
Regards
Dazza
 
No worries folks I have found the answer. Basically I use an unbound list
box then on the forms "On_Current" and "On_Open" events I use the following
code:

Me.lstCaseList.Rowsource = "SELECT * FROM Vi_CaseList WHERE CustomerID = " &
Me.txtCustomerID

Me.lstCaseList.Requery

Works a treat. You can also use this method for combo-boxes where the
content of the second combo is dependant on that selected on the first
(Category and Sub-Category)

Hth anyone with the same problem.
:o)
 
Back
Top