8 Jun 12 16:30
I am very new to Access forms. Hopefully I can find a little help.
First, I would like to find some good forms training leads. If you know where I might find good forms training please share it with me.
I am working on a form where I want a combo box to allow me to select a client and then have rhe form populated with the client information. Further I plwn to put buttons on the form that will take me to other forms where I can edit the data displayed on the initial form or where I can enter data for a new client.
I have a table titled "Companies" that has the data on each client. I have a field titled "Company Name" as well as several others.
I have a combo box that displays the company name when clicked. This works. I have a query titled "QryComSelect" that has all of the fields in the "Company Name" table. The "Company Name" field of the query is populated by the combo box and when a choice is made with the combo box the query shows the entire record of that company.
I have a text box with the following in the control source:
=DLookUp("[companies]","[qrycomselect]" & [Forms]![frmcompanyview]![combo2])
This text box simply says "#Error".
I need to put several text boxes on the form, each pointing to a field in the table or query to show the information contained.
I appreciate any help you may be able to provide.