Search results

In have tried Me.requery, me.refresh, DoCmd.RunCommand acCmdSaveRecord, and a host of other acCmd's. None of them re ran the form. I don't know how to call the action. It's what happens when you close the form and open it back up. The whole thing gets re-run. I cannot see the results of the...

I don't know how to ask any better or more clearly then I have already. I set the startup now so it will go directly to the the form that he will filter. Now he is going to hit he filter by form icon (it has the funnel icon in front of the form icon) He wants to type in his criteria in the...

We are going in two different ways. I first had a problem/issue and could not solve it so I started working around the problem to find a different solution. This thread is an issue I got with a piece of code in the workaround. Well now I've got two issues with my new work around. However the...

What command is needed in the code to do the same thing as closing the form and reopening it? What else can I try. I do not know what gemma means. I have tried refresh and requery what else can I try?

Here is a screenshot. Sorry for not being better prepared.

I'll try to explain this better. This is a db I'm building for a client. The cstfrm is the main form he works from. At the top of the form is customer info. inset into the cstfrm is 4 subforms. a form for comments called commentsubfrm labeled action. a form for orders called ordersubfrm a...

Subdatasheets in the tables, no.

Sorry for not getting back to you, coloring Easter eggs. I have not set up relationship in the db. I know that sounds pretty novice. I have no reason why I haven't. However there is a relation between the tables Customertbl.customerid=ordertbl.customerid...

Gemma, Thanks for the reply. I'm not sure what you are telling me? the command button is in the footer of the form. I want the onclick function to requery the form and all the subforms. There are 4 subforms. actionsubform ordersubform statussubform instsubform do I nned to requery each...

Adam, Thanks for the reply. No I wasn't able to fix it like I wanted. I had to restructure the record sources of the form and the subforms. Part of the fix was the the button I put on the form. It calls up a query. He will then add the criteria to the query. He saves it and closes ir. That...

In order to solve a subform filter problem I put a command button on the form that opens a query that is linked to the form's recordsource query. The customer selects the button, fills in his criteria, saves the query and closes the query. The form still shows all the records. So I added a...

Do I need to add look up boxes? I have a earlier post on this and I didn' get an answer. http://www.access-programmers.co.uk/forums/showthread.php?t=145843 There is no way of finding the records he selected while in the filter by form state and use that in your select statement somehow?

What about if they are filtering a subform in the form? It filters the subform yes. But how can you tell the program to filter the main form by the filtered records in the subform?

yes he wants to select the filter by form and then fill in his criteria in the fields respectively. open up db>close reports>select customer form>select filter by form in the tool bar>go to the action subform and select 12 for the action ID> select filter in the toolbar what he wants to see...

All do respect Adam I don't get it.

Here's my db after I cleaned out some stuff.

I need some direction, again! I'm almost exhausted with this project yet I got a last minute request from it's owner. From the form he wants to be able to filter it's content by choosing the criteria in the filter by form button in the toolbar. Some of the criteria falls in the subforms I...

Gemma, I think I understand it now. However I would never had understood it without Bob's and Forum help. I have not tried raskew's code though, no offense raskew. But I do understand why mine failed. Thanks for the post and the information. If only I can find as helpful posters for a...

Bob Larson, Again a HUGE THANKS! I took out the "(" and added Me.expiredate and it works perfectly. At least for right now. I have not tried tofit the other suggestion in. I'm sure with enough help I could be told how to take that and replace what I had, but that is for a differnt day. What...

Thanks for the lesson. I'm not sure what it was supposed to do but I'm back to square one I think. I posted some screenshots of what I did and what I got. Is there something I have to add after the then?