Search results

Thank you very much for your help

I see where is says "inner join." How do I correct this?

SELECT Employee.ID, Employee.LastName, Employee.FirstName, Employee.SSN, Employee.CompanyName, Employee.ClientName, Employee.Division, Employee.ClientState, Employee.JobTitle, Employee.Branch, Employee.Notes, Employee.HotList, Injury.ID AS ID_Injury, Injury.ID AS ID_Injury1, Injury.EmployeeID...

Everything seems to be good as far as that goes. When I switch back to the form I used the wizard to make, everything works find. It has to be something I did with the way I made the tabbed forms. I just created a blank form, made the tabs and dropped the existing fields in the respective tab.

It says the control source is my employee table

When I created it, I just added existing fields from each table I was using. It allows me to enter data and it saves it to the table, but then I can't pull it back up with that form.

Hello, I created a database for my company to track injuries and root causes of injuries. I was using a standard access form to input the data but wanted to make something more user friendly and better to look at instead of the linked tables. I created a 3 tab form with Employee info, Injury...