I have a list box control on a form and I am trying to set the recordsource property to a stored procedure. I am trying to avoid doing this at runtime. The stored procedure takes a single parameter @District, which is a value on the main form. How do I pass the value in my form [Forms]![frmDistInfo]![DistCode] into the stored procedure for that list box? Currently when I open the form it prompts me to enter the District.
TIA...
TIA...