Topic: Update records in database from different forms
Hello All at MVD,
This question probably has been explained in numerous ocassions but I've searched the forum looking for something to solve
my problem and frankly didn't find it. I have a multiple tables and several forms. In the main form, I show a grid that displays
an employee database with different fields, idnumber, name, department, ss#, hiring date. I have a button to add new records,
in this form, you add the information that will appear on the grid with the corresponding fields. I want to add another button to this
form ( the new record form ) that will open up another form to enter additional actions to be taken on that particular employee,
i.e. vacation, leave of absence, medical leave, destitution, etc. This new form will have two combo boxes that display values to be
chosen, memo field, and other things. What I want to do is to bring the information I have from form1 (New record form) and display it on this second form (Actions Form)
plus save the new information from the combo boxes and memo fields , all in the same record in the database. Is this possible? Please help!!
Thanks.