Search results

Won't that automatically add what the user types to the list and my Parts Table??

I have a main form that allows the user to select a workorder from a combo box. This will filter my continuous subform below it. I then want the user to enter any parts used for this work order. Here is the problem. The user can select an existing part or enter a new one(but I do not want the...

Duh on my part. Sorry but I do not know why I didn't realize I was setting the EmpId to the combo box as being calculated. I have never set the master to a cmb before. It all seems clear to me now. I must say I have learned a great deal with this. Thanks a million!!!!

If I take my sum total out of the footer of the subform it does not flicker. Is it not related to the textbox that it is summing? I need to get the total number of hours from the subform and display it in the main form. And niether of my master/child links are a calculated field so not sure how...

hmm Ok I think I may be even more confused now after reading your post. I didn't think there was anything wrong with my master/child links. The reason I have empID and DateWorked as links is because I want the user to select and employye on the parent form. Then enter a date to enter hours for...

Ok now I have an issue with totaling on the subform. I have a main form(frmEmpHours) and a subform(subfrmEmpHours). I added a textbox to the sub forms footer to total the number of hours. When I open the main form, you select an employee(first on in the list) then enter a date(for testing...

ok i finally got it!! Thanks so much!!! I thought I had it linkin on empid and date but for some reason it was not. That works lik a charm!!!!!!!!!

does your combo box actually have 4 columns?

what is the code for your combo box? Does it have multiple columns?

I added the requery and tried assigning the DateWorked field on the sub to the DateWorked field on the main and it still does not filter based upon the date entered. Any other ideas?

So I deleted my subform from the main form. Then re-added it using the wizard and defined my link fields as empID and DateWorked. It does not work. When I select an employee it shows all the records for that employee.(I do not want it to filter until they enter the date). Then when I enter the...

sorry i didnt attach the database

I actually attached the wrong database. I am attaching the correct one. The subform child and master links is the empID. Can I add Date as well? This will allow them to add additional records in the subform using the date and emp id from the main form? Sorry but have only ever linked on one...

Hi all. I have read tons of posts on here and cannot find exactly what I am looking for. I have a main form that contains a continuous subform. The main form has the user select and employee from a combo box and then has them enter a dtae. I would like to show only those records with that...

Thanks Waaz!!! Works like a charm!!! And filters correctly in my navigation bar. I appreciate everyone's help as always!

Here is the issue when I apply the filter. I applied a filter and turned the filter on. This WILL pull the correct information for the Family I just added. HOWEVER, I have record selectors on the bottom f the form that allows the user to go through the different records. It now says Filtered and...

Yes I used my form name and cmbo box name and that is what does not work: Docmd.RunCmd acCommand acSaveRecord Forms!frmFamilyStudent.Requery Forms!frmFamilyStudent!cmbFamilyName.Requery 'perhaps not required Forms!frmFamilyStudent!cmbFamilyName= Me.FamilyId Forms!frmFamilyStudent.Requery

Thanks but I actually have that exact code in there right now and it does not work. The form does stay open while the other one is open as well. Any other ideas? I do not know why this seems so difficult for me. Any help is greatly appreciated!

I have a form that allows a user to add a new family or edit a family. When the user clicks the save button, if they are adding the family for the first time, I want to enter todays date in a field(Date added). If they are editing the family info I want to add todays date in the filed(Date...

I have a form(Family Info) that has a combo box containing a list of family names. The form displays details about the family based on the family selected in the combo box. I have a button on this form to Add a Family. This opens a blank form to enter a new family. When I click the save button...