Hey guys,
I have a simple question that I was hoping someone could help me out with. I have a couple of tables,a query,a report, and a form. I want to use the form in such a way that the user selects a associate from a combobox(cboName)(populated with data from tblAssociate) and that displays a record that relates to that assocaite. Now, there are multiple records for each assocaite so the user would have ot be able to navigate through them. (I would also like the user to be able to add new records and delate records through the form) I wan thte records to display in textboxes so they can edit the records in need be. I know how to set it up so that the user can select an associate from cboName and preview a report based on the parameter query qryDuty. But I can not get the data to display in the textboxes (txtDuty, txtDesc1, txtdesc2, txtDesc3)
I am pretty new to Access forms and have little experience with VBA. I would be so grateful for any help anyone could lend me. I am trying to help out my boss with this and I am an intern trying to make a good impression as the summer comes to a close.
Thanks again in advance,
Brent
I have a simple question that I was hoping someone could help me out with. I have a couple of tables,a query,a report, and a form. I want to use the form in such a way that the user selects a associate from a combobox(cboName)(populated with data from tblAssociate) and that displays a record that relates to that assocaite. Now, there are multiple records for each assocaite so the user would have ot be able to navigate through them. (I would also like the user to be able to add new records and delate records through the form) I wan thte records to display in textboxes so they can edit the records in need be. I know how to set it up so that the user can select an associate from cboName and preview a report based on the parameter query qryDuty. But I can not get the data to display in the textboxes (txtDuty, txtDesc1, txtdesc2, txtDesc3)
I am pretty new to Access forms and have little experience with VBA. I would be so grateful for any help anyone could lend me. I am trying to help out my boss with this and I am an intern trying to make a good impression as the summer comes to a close.
Thanks again in advance,
Brent