Search results

I'm now making good progress on this CJ. The problem was I didn't have a column in my subform table that helped with the link to the ID in the mainform. Once I created a recordsource in the subform tabled called "MainFormID" and made it the child to the main form ID as parent, it all...

Yes, the form and subform seem to work. I just can't seem to find the key to getting both the main form and subform to report together. I just need to make sure that any data I enter on the subform is linked ONLY to the specific record on the main form. Since the ID is the "link" between...

I know I'm not making myself clear...I'm sorry. I have a clear picture in my head of how I want this to work but I'm just not able to express it in the correct terms.:banghead: The main form is the original service ticket for a broken device. The subform is where people will enter ongoing...

OK...hitting a wall with this. I have the main report, and I'm using the Subform/Subreport wizard button to draw the box. However, I can't get the subform recordsource data to populate in the subreport. The main form and subform are linked by the main form ID. What am I missing?

Yup. I'm working on it right now! Thanks!

My main goal is to have a report that shows the original maintenance request from the main form as the top half of the report, and then a box of data on the lower half of the form that shows all related maintenance progress from the subform. Thoughts?

OK...so things are going along much better with the subform. Data is populating into the subform table. I haven't solved the "Can't assign a value to this object" problem yet but I'm working on it. Next question is how to combine the data from both the main form table and subform table...

OK...I may be on the right track. I scrubbed my subform and created a new one with the wizard, and selected the correct subform recordsources, and used the main form ID as the "child" However, now I'm getting a "You can't assign a value to this object" error when I try to enter the date...

Thanks CJ. Right now, there are no records in the subform table. I was counting on the maintenance update data that I entered to be populated in there. Then I was going to create a report that pulled data from the tblmain and tblSubform to show the progression of the work order from...

OK...so all of my text boxes in the SUBFORM are currently UNBOUND. What should they be bound to? The fields in the SUBFORM TABLE, correct? And when you say "MainID long" do you mean "Long Integer?" Thanks CJ!

Thanks CJ. I'm getting back to this first thing Monday morning and will report progress. I appreciate you hanging in there with me!

OK. I have the ID field from my main form as the "child" relationship in the subform. Now I need to use a bunch of textboxes to populate "progress report" data For example, on a specific date, a specific action was taken. I need to populate the date field, the action taken field, the...

Thanks so much for the advice. I'm going to try this shortly and report back to you. I'll also let you know if it leads to any other questions!

:)Hello... I'm sure that someone has a quick solution to this. Basically, I've created a form to track maintenance requests for specific types of equipment. Basically it's like a ticketing system. Once a user creates the request, I want to use a subform (I guess this is the best...

Hello everyone. I've created Access DB's in the past and have always been able to fight my way through problems with online research and trial and error. But I'm trying something that I've never done before and I simply can't get it to happen the way I would like.:banghead: I have a...

OK...I've gotten the data from both tables to populate in the report via a query, but now the data is repeating. Must be some issue with the JOIN, but I'm not sure how to make it stop!

I've tried using the wizard but no luck. I'm using a tabbed form. There's a lot of data fields for inventory information and it is spread out over several tabs. The last tab contains the subform for the trouble tickets. The way the main form is set up is that I have four fields...

Hello all.... I've finally broken down and decided to consult this forum personally for help! I've learned so much from lurking at various threads as I've researched different topics on Access, but I've hit a wall and really need help. I'm trying to create a report that contains data...