Recent content by jadefury

Wow that worked you are a hero today! Thank you so much!

still getting a run-time error '2465': application-defined or object-defined error Thanks again you have been a big help

okay getting an error "application-defined or object-defined error" I added the code into the save record button. The code as it stands currently is as follows: Private Sub Command107_Click() On Error GoTo Err_Command107_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

Yes they are named the same subcaredb1 for subform1 and dep2 for subform2

How do I find that out? Sorry I have been playing around in access for awhile and I am only using the subforms as subforms I did not rename them when I added them as a sub form. I hope that answers the question

I hope I answered that question correctly, but both subforms are linked by customer id not for sure what else you are looking for. Thanks!

subform 1 is called "subcaredb1" subform 2 is called "dep2"

I don't know hardly anything about VBA programming I just want a button that will requery my first and second subforms while still in the main form. Can you give me any additional assistance. Thanks!

I have a main form and sub form. The subform is linked to a query as the information pertains to an employee id. I need the subform to update as soon as the main form record is saved. I have a button that saves the information. Where and how do I get the subform to immediately display the...

Thanks Boblarson it worked

still all that does is is group the option groups together so for example in option group 1 the third check box is checked and in option group two the 2nd check box is checked I get:21 It isn't adding the values from each option group already assigned it is just listing them in a row. Thanks!

is the 1,0 in the above formula trying to assign a value to the checkbox for example if checked =1 or not checked = 0. The formula does not seem to work as I have four check boxes in an option group. The values of the check boxes are again already assigned from 0-3.

I am looking to do a single form sum. I have already created my option groups and assigned a value to each check box. I have an unbound text box and was trying to use this formula =sum[q1]+[q2]+[q3] The answer I am getting is from all forms and it is not totaling the numbers it is just...

it already has a ton of tabs on the form or I would have just added a tab.

Could someone break down openargs for me please? I am new to access have taken several access classes I even have the access 2003 bible, but this concept is very new to me. I need the main form to link to a secondary form using the same table. I need the employee information to match to it is...