I created 2 tables. One housing a list of all the Names we have, the 2nd is a table for reports "made" for the different Names we have. From there I created a Query using data from both these tables. Mainly the naming conventions fields from the Names Table and essentially all the fields from the Reports Table.
With Wizard I created a form based on my query's information so that the naming conventions auto-populate. when the Name control has the drop-down, the user selects and the information pops up. The second have of the form a user would enter the details in the controls that match the fields in the Report Table and save.
The problem. Form DATA for the most part populates the fields in the Report Table, except for the 2 naming conventions that auto-populate in the forms. So I have all the report DATA fields but I don't have First Name or Last Name in my report table. However, the query has all the data when I run it.
I don't have any calculations in my form. I can't for the life of me figure out what to do with the control source and I am wondering If I should have not created a form from a query as it's not relaying the information back to the reports table completely.
Does anyone know where the blip was?
With Wizard I created a form based on my query's information so that the naming conventions auto-populate. when the Name control has the drop-down, the user selects and the information pops up. The second have of the form a user would enter the details in the controls that match the fields in the Report Table and save.
The problem. Form DATA for the most part populates the fields in the Report Table, except for the 2 naming conventions that auto-populate in the forms. So I have all the report DATA fields but I don't have First Name or Last Name in my report table. However, the query has all the data when I run it.
I don't have any calculations in my form. I can't for the life of me figure out what to do with the control source and I am wondering If I should have not created a form from a query as it's not relaying the information back to the reports table completely.
Does anyone know where the blip was?