Need help with Forms

[Pat Hartman]

How can we help you if you don't try the suggestions or provide helpful information? If you look at #10, I explained how you can use the same form but open it in add mode or edit mode. It isn't what I do. I explained that later but it will allow you to use a single form for both data entry and update. You just have two open buttons. One for add and one for edit and use the options of the OpenForm Method to control how the form opens.

 

[Gasman]

Not really

Well post #3 will do exactly what you want.

You have to do some work yourself you know. We are here to help, not serve.

 

[mpasta]

How can we help you if you don't try the suggestions or provide helpful information? If you look at #10, I explained how you can use the same form but open it in add mode or edit mode. It isn't what I do. I explained that later but it will allow you to use a single form for both data entry and update. You just have two open buttons. One for add and one for edit and use the options of the OpenForm Method to control how the form opens.

Let's not assume that I don't want or have not tried the suggestions listed. I explained that I am quite the novice with this and instead maybe assume that I still do not quite understand how to implement the suggestions. Be kind.

 

[Pat Hartman]

You said you didn't try any of the suggestions. What are we supposed to think? No one is being unkind. None of us gets paid to help you and we sometimes need to point that out to new members who come here thinking we will build applications for them for free. When we give you actionable suggestions and you can't be bothered to even try to implement them we might get a little testy. Just because we are not charging for our time doesn't mean that it has no value.

We are happy to help you but you have to put forth some effort. Simply reading the help entry for OpenForm or paying attention to the intellisense when you type in the expression might have given you the clue that the OpenForm Method could open in either Add or Edit mode. You still might need help to work out how best to implement that two-way opening. If you don't understand what we suggest, tell us and we'll go into more detail. I post lots of samples that I have made over the years. Some people even make them on the fly to explain your specific problem.

Any sample I might have posted would have used the method I use. That may be too advanced for you at this point so taking advantage of the built in option of opening a form to add or edit, should solve your problem for now. Please give it a go.

 

[Gasman]

Don't post responses like this then.

 

[mpasta]

You said you didn't try any of the suggestions. What are we supposed to think? No one is being unkind. None of us gets paid to help you and we sometimes need to point that out to new members who come here thinking we will build applications for them for free. When we give you actionable suggestions and you can't be bothered to even try to implement them we might get a little testy. Just because we are not charging for our time doesn't mean that it has no value.

We are happy to help you but you have to put forth some effort. Simply reading the help entry for OpenForm or paying attention to the intellisense when you type in the expression might have given you the clue that the OpenForm Method could open in either Add or Edit mode. You still might need help to work out how best to implement that two-way opening. If you don't understand what we suggest, tell us and we'll go into more detail. I post lots of samples that I have made over the years. Some people even make them on the fly to explain your specific problem.

Any sample I might have posted would have used the method I use. That may be too advanced for you at this point so taking advantage of the built in option of opening a form to add or edit, should solve your problem for now. Please give it a go.

I see the confusion; I was answering the first question; was I able to solve the issue? I didn't ask anyone to build anything for free. I read all the threads. Please consider this closed. Thank you for your time.

 

[Pat Hartman]

If you didn't solve the issue, why close the thread? BTW, to close the thread, YOU would mark it as solved. If you had questions, why not ask them?

 

[Gasman]

Just go with Data Entry =Yes then.

 

[mpasta]

Just go with Data Entry =Yes then.

Thank you; done.

 

[mpasta]

Just go with Data Entry =Yes then.

Quick additional question. When I hit TAB initially my form was tabbing down the left column of the screen (which is what I need it to do). I moved the fields on the right side of the screen up and now when I hit tab it takes me from top right field to top left. How do I correct this? I tried lowering the fields on right side just in case it was a simple as that, but it did not fix the issue. I'm not sure what I changed to cause that.

 

[Gasman]

Set your required Tab Order in the form design tab.
You can try the Auto Order to see if that gets you what you want.

 

[mpasta]

Set your required Tab Order in the form design tab.
You can try the Auto Order to see if that gets you what you want.

Thank you! All fixed.