Search results

Okay I created a report (rptMultiSelectqry) it seems to have the same Record Source as the form. Remember, this is from the form frmMultiSelectqry. frmSupplierDescriptionCodeqry does not seem to have this issue.

Okay, yeah I see the Row Source on my combo box was empty. But I thought that filter was working??? If I were to sort the drop down in ascending order would this be the correct code?: SELECT Format([Purchase_Date],"m-yyyy") AS MyMonthYear FROM Equipment GROUP BY Format([Purchase_Date],"m-yyyy")...

Okay understood. But we’re going to add the filters to the parent form, “Program Customer ModelYear”. I’m sorry if I’m repeating myself, I just want to make sure I’m on the same page.

I’m not quite following. I add this: SELECT Format([Purchase_Date],"m-yyyy") AS MyMonthYear FROM Equipment GROUP BY Format([Purchase_Date],"m-yyyy") HAVING (((Format([Purchase_Date],"m-yyyy"))<>" ")); to the Row Source of cboMonthYear? I don’t have any reports, I was just creating one...

Yes correct, to filter on Program, Customer and ModelYear. Just to make sure, this is in the form named "Program Customer ModelYear". And that is considered the parent form and "Program Customer Model Year form" is considered the child (with a subform)?

I know. I'm sorry. It's not my idea. I'm working on this db with someone else. As you can see some of the naming convention is ok, some not so much.

Program Customer ModelYear is the form that I would like to filter the records on. That in turn opens up Program Customer Model Year form (which has a subform). Originally, I was thinking of a way to filter the second form from the first. But now I would just like to filter the records in the...

Ok attached is the db. Query name is qryProgramCustomerPKGEngineer. Form is called Program Customer ModelYear.

There is no subform. Not sure what is meant by “being run on a navigation form”? This is the query you told me to create. When I took out the second table the query worked and returned the proper number of records.

Glad to see you back. I think I got the code correctly in there. Have been playing with it and it returns all the correct dates. But I'm still having a problem with the supplier name not coming through when I create a report off of a filtered search. On the form frmMultiSelectqry if you...

Ok so I tried one criteria for OEM code: SELECT [Packaging information charts - Copy Of].OEM, [Packaging information charts - Copy Of].Program, [Program Customer ModelYear].PKGEngineer FROM [Packaging information charts - Copy Of], [Program Customer ModelYear] WHERE ((([Packaging information...

Ok, so far: -There is no Source Object on the form, there's a Record Source. Do I change that to the query I created? -Query sql code: SELECT [Packaging information charts - Copy Of].OEM, [Packaging information charts - Copy Of].Program, [Program Customer ModelYear].PKGEngineer FROM [Packaging...

I don't know how to do either option. Also, there is no subform.

I believe I am going about this the wrong way, as you guys have mentioned before. So... Is there a way to filter a form that's in continuous form view? I have attached a screen shot of the present form. I would like to be able to filter on Program, Customer and/or PKG Engineer. What I was...

vbaInet: I tried the second option in #42 post. But that didn't work for me. I obviously don't think I did it correctly. But when I tried it, it give me five parameter when I try opening the form after making a selection from the switchboard. And when the form does open it doesn't display...

vbaInet and Uncle Gizmo - Thank you both for your input and guidance. I will be starting to work on this again in the next couple hours. I'm sure once I do I will have many questions as to how to implement certain things that have been mentioned by both of you.

I'm not sure what this means? In any case, it sounded like in Uncle Gizmo video that he was not sure what to do. Okay, forget the way it's set up in the database. How can I have two combo boxes set the search criteria that will open up a form with the matching criteria in the subform? The...

vbaInet and RainLover: Thank you both for your input. Thank you again for reading my post. I will wait to see what Uncle Gizmo thinks I should do.

Rainlover: I'm sorry I had it posted but decided to take it down because it had peoples names in it and didn't get there permission to post the db. I can repost if you would like for a little bit in order for you to look at it. vbaInet and Rainlover sorry you guys are fast in your replies and...

vbaInet thank you for your reply. I'm sorry, I'm not explaining myself very well. They aren't supposed to be in both forms. One form (the switchboard) is used to open another based on values in combo boxes that aren't editable. They’re in a continuous format and which every record set is...