Hello everyone,
I am trying to create a Maintenance Log DB. I need to create a log entry with a date, customer info, and Rig info. I want the Rig info to be in the tblLoftRecord and not change when the rig it self has any changes. I have a Form frmLoftRecord that pulls the info from different sources and displays all the info I want after the few selections I have to pick from. I have got it able to update with a button running SQL statement. The problem is the form gets updates and created from Combo Boxes, date box and several other form fields. When I click the button is runs the SQL command and creates a new record with that info. I also put the form and table n a group called test. Right at the top.
Thanks for any help.
Shannon
Loft2.zip