M
Mark L via AccessMonster.com
This is my first attempt using Acess as a front end for a SQL database. I
have a straight Access database using an input form with a combo box of job
numbers and a list box of addresses. Based on the job number in the combo
box, I requery the list box to show the associated address(es). I made a
stored procedure named spLstJobAddress with =@Job_Nbr in the criteria coumn
of the fldJob_Nbr of my table. I put @Job_Nbr = [Forms]![frmJobSiteInfo]!
[cboJob_Nbr] in the Input Parameters line of my Access Form. I have placed
spLstJobAddress in the row source of the list box. I do a list box requery
after the combo box updates. I get a prompt after the combo box updates.
HELP!!
Do you have an excellant reference for developing Access Projects?
have a straight Access database using an input form with a combo box of job
numbers and a list box of addresses. Based on the job number in the combo
box, I requery the list box to show the associated address(es). I made a
stored procedure named spLstJobAddress with =@Job_Nbr in the criteria coumn
of the fldJob_Nbr of my table. I put @Job_Nbr = [Forms]![frmJobSiteInfo]!
[cboJob_Nbr] in the Input Parameters line of my Access Form. I have placed
spLstJobAddress in the row source of the list box. I do a list box requery
after the combo box updates. I get a prompt after the combo box updates.
HELP!!
Do you have an excellant reference for developing Access Projects?