Search results

I am trying to calculate something to me put into a field called 'finalRptCycleTime_BeforeUpdate'. I want to take the 'auditEndDate' box to be subtracted from the current date and the answer to be put into the 'finalRptCycleTime' field. Here's what I have in the finalRptCycleTime before update...

I have a form with which I select a year from a dropdown combo box. I want to open up a report after I select the year. How do I do that?

My company has a database. I downloaded a copy of it to my desktop to work on it. Can I integrate my changes to the original? (copy/paste,export etc) I hope so.

I think I got it. Instead of using a textbox, I used a listbox that's shrunk down to a textbook 1-field size. It works fine.

I choose a ‘Year’ from a combo box. Why doesn’t the data in my textbox update? (It’s a count of records for that year)

Yes, the subform does have two fiels listed in the parent/child links. Does that matter? I'll look at it tomorrow.

I have 2 cascading combo boxes which control what appears in my subform (AuditYear,Company). Once I select both, sometimes the subform info shows up and a while later I try again, and it doesn't. Then I try some other AuditYear + Company, then THAT shows up...then I try again, it doesn't. Any...

never mind, a search in the forums did the trick.

another question,sorry. I have now gotten the part where I select the 'Year' and the correct 'Companies' show up. Now I want to click and select a company from that list, and I want the rest of the form to change accordingly. Subform? What's master/child anyway, I was tinkering with it...

I guess I'll have to wait til I get home to view this one.

don't know if it's just my PC but the first link didn't work.

Thanks rural. It's actually called 'yearAudit' but I just used 'year' to simplify. Didn't know it was reserved though, so thanks. While we're here could I ask another question? I don't want any edits I make to be saved UNTIL I hit the 'save' button. Any idea where I could look this info up?

I have 2 combo boxes. 1 is year, the other is company. Let's called them 'cboYear' and 'cboCompany'. The fields inside the combo boxes are from tables called 'Year' and 'Company'. I select from a drop down menu and populate a table called 'Audit Records'. I would like to create a form that...

anyone? :D

If I choose a Category from the combo box, it gives me a group of Products associated with the Category (in another combo) Now I want to choose a Product, and I want the rest of the my info in the form to change to the specifics of the product (these specifics are in text boxes). I realize it...

That's if you know you have A,B,C and you have to actually go back in and edit the code if you add D,E,F right?

Well, this is what I'm trying to do. Sorry I wasn't clearer. I have a combo box with a list of things (A,B,C etc) "A" has a corresponding message that is associated with it. "B" has a corresponding message. When I select from the list (eg...I choose "B"), I want a certain text box to change...

bump bump ..

I read this article for combo based on combo. http://office.microsoft.com/en-us/assistance/HA011730581033.aspx But now I have a textbox whose contents I want to change based on a choice in a combobox. I don't know the code for it. Anyone can help me out some? I went to the combo box and tried...