Another issue I am having problems with

[balderman]

I am finally almost finished with my database at work and I appreciate all the help that I have gotten so far!



I have a form for Customer's Info and a Subform containing all their work orders. That is working great. I also created a form for Maintenance Contract Information for customer's who have a maintenance contract. I was able to create a button on my form/subform to view the Maint contract Information form but it won't let me enter a new record, it says you cannot add/change a record because you need a related record in table tblcustomers....but when I tested this I added a new customer record first before I attempted to add the main contract information so I cannot figure out the best way to do this.

[RuralGuy]

Did you save the new customer record first?

[balderman]

yes I did...I even tried saving it and closing the form then reopening it and going back to it

[ArviLaanemets]

What about saving new customer, then closing the program and reopening? Can you after that add maintenance contract for new customer?

[RuralGuy]

What code/macro do you have behind the button?

[balderman]

I have the open form button on the customer profile/work orders form and then on the maint contract form I have the add new record button

[balderman]

and no, even after saving, closing the database and reopening it still will not let me

[RuralGuy]

If you highlight the button in design view and look at the Events tab of the properties sheet and then click on the "..." it should show what is in there. Copy and paste to a post please.

[balderman]

[RuralGuy]

On your Maintenance Contract Information Form/SubForm arrangement, to what have you set the SubFormControl's LinkMaster/ChildFields?

[balderman]

I have a customer profile and work order form that is a form/subform and then I have a separate form for the maint contract info.

[balderman]

I'm sorry I don't know what you mean by LinkMaster/Childfields

[RuralGuy]

Just an FYI but your tblMaintContract and tblCustomers tables have duplicated field which is a no-no. All of the fields should be atomic and not be duplicated anywhere else in the RDBMS. That also points out that the tblMaintContract has fields that really belong in another table (1st and 2nd stuff). So you are saying the MaintContract Form is *NOT* a Form/SubForm arrangement?

[balderman]

OK so I should use the first name and last name fields from my customers table in the maint contract form? And no, it is not a form subform. I just want to be able to click on it from the customer profile/work order form/subform and have it open up separately and display the maint contract information (if there is any) or to be able to add a new record to start a maint contract for that customer

[RuralGuy]

A SubForm is displayed on a Form with the use of a SubFormControl. MS Access defaults the name of the SubFormControl to the name of the "SubForm" it is displaying but it does not have to stay that way. The SubFormControl is hard to select but it is just an interface issue. You'll know you have the SubFormControl selected when the data tab of the properties shett has the thwo properties LinkMasterFields and LinkChildFields. If properly set, the subform will fill in the proper value for the LinkField when you do an add new.