Search results

(solved) error 2950 - TGIF SOLVED: See link below http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html I've been working on an access database at work. I have a form, with a button on it, that opens another form with certain criteria. I have never gotten this...

I knew that wouldn't be the final question.. but here it is!: If I choose an employee in my first combo box, and then select a second employee, the second combo box doesn't update - it still shows the projects for the first employee. How do I fix this?

Dairy - that wasn't exactly the same thing I was doing but for some reason it clicked in my head what I needed to do! Made a new query, set the criteria to my combo button, realized I needed to add all the fields in the query that were going to be in the report - and bam! it works! final...

Trevor, I am not a worthy student. Your last went entirely over my head - maybe it's too early :p. I tried your method, created a text box, couldn't really add it to the after update on my combobox because theres already a macro running in there to requery. In the data properties for the...

Trevor: Thanks again for the reply, going to take me a minute to try to implement what you suggested. Dairy: I tried putting a filter on my report in the Data tab of the properties. In the filter I tried & I wasn't sure if 'ReportProject' was supposed to be renamed to the name of my project...

Trevor, again, Thank you for your help. I copied your code and replaced it with the names from my database. Is what it turns out to. I used Combo2 for the combo box because my form differs from yours in that when you make the selection in the combo box it does not show it in another spot on...

It's for something at work, so I cant :/. I've created a macro button on my form and I'm getting it to open a report with the fields on it I would like, but it's not filtering them via the criteria in the form. The macro condition is: Forms![Sean]![Combo2].AfterUpdate Combo2 is the second...

Trevor, Thanks for your reply.. when I create a macro (which I'm doing from my form), I'm using OpenReport as the action. For the conditions in the expression builder I'm confused as to what to enter. The table and field for the second combo box on my form (which sets the specific criteria...

Hello all, I have a form with two combo buttons - the first selects an employee, the second then shows the projects for which they are responsible. Once the user selects the desired project I need a button (or this could be an automatic event upon selection) that generates a report. I've made...

I know there's a macro involved. The afterupdate event is [embedded macro] and the macro is called "Staff Search Requery" and then theres one for the second combo button called "Project Search Requery" but I see NO SIGN of them in the data properties.

Hello all, I'm quite quite new to MS Access, picking up where a previous employee who was quite trained, left off. I'm trying to create a form that has two combo boxes which will let me select an employee, then a project their assigned to, and then press a button to see a report of all weekly...