The form opens but is blank.
If I add the company ID and Name to the Ratings Table - it works because it has record to open.
Maybe I can INSERT INTO the Ratings table the CompanyID and Name when I add the companies.
Here's the code for the button:
Private Sub SubmitRatingBtn_Click()
DoCmd.OpenForm "CompanyListF", , , "CompanyID = " & Me!CompanyID, acFormAdd
End Sub
There may not be a record for the company in the rating table if it hasn't been rated yet.
Calculations would be made with a query and...
I need for my users to be able to rate a company. My plan was to have a table that would keep each rating in a record for the specific company. When the company information is displayed, a query would average the rates for that company and display on the form, report. (This works from my test...