Copy of Form -- Button doesn't Work

[Hey Lucy]

I have a form with a button that opens another form if certain conditions are met. I made a copy of that same form without altering anything, just copy and paste, but when I click that same button on the copy of the form, it asks for a parameter value. Doesn't do this on original form.

I've actually never seen this happen before. I copy forms then alter the copy for different users to be locked out of accessing certain fields and it has always worked. I am so puzzled over this.

Any ideas? Has anybody had this happen before?

 

[acarterczyz]

I have a form with a button that opens another form if certain conditions are met. I made a copy of that same form without altering anything, just copy and paste, but when I click that same button on the copy of the form, it asks for a parameter value. Doesn't do this on original form.

I've actually never seen this happen before. I copy forms then alter the copy for different users to be locked out of accessing certain fields and it has always worked. I am so puzzled over this.

Any ideas? Has anybody had this happen before?

Is the Event setup for this button? If so, can you paste the code?

 

[Catalina]

Using multiple forms in order to restrict users does not seem to be an appropriate practice.

Why not give users a user level and on opening the form determine what the user can
and cannot do given the user level. That way there is only one form to maintain.

Or am I not seeing this the right way?

Catalina

 

[Hey Lucy]

Thanks Catalina. I don't know VB and can't seem to find a way to create user levels within Access programming itself. What we have decided to do is alter copies of forms that users will get as fe's. It has been working so I don't know why I'm all of a sudden having an issue with this.

Basically, all I want is a copy of this form with certain fields locked. Sounds simple enough, and like I say, has been working. At the very least, the buttons should work. It's just a copy. ???

 

[Catalina]

Can you give something more to go on, like the code you are using behind the button or may be a stripped down version of the db?

Catalina

 

[Hey Lucy]

Thanks so much for trying to help me. I have attached screen shots that may make it easier to understand.

Look at the Main Form screenshot. This is my main form. You will see a button at the bottom called "Initiate Contract". When I click the button, it opens up the Contract Form.

Look at the Contract Form screenshot. This is what is opened by clicking the "Initiate Contract" button. (At this point an agent is assigned and a contract is initiated and given a Contract ID by Access). Works perfectly.

Now look at the Error on Click of Button Initiate Contract screenshot. Do you see the message box asking for a parameter value?

This is what I get when I click the "Initiate Contract" button in my new form, "All Properties Offers ONLY".

I generate the "All Properties Offers ONLY" form by simply copying and pasting the Main Form and giving it a different name. No changes whatsoever have been made to the form at this point. (I would, however, go back and lock all the fields on the form except the ones in the Offers subform)

I also included a screenshot of the OnClick event of the button called Button Macro - On Click.

This is the same on both the Main Form and All Property Offers ONLY. Should do the same thing, right? Instead on the copied form, it asks for a parameter value.

I really don't understand. This is what I've been doing and it's been working. :banghead:

 

[Hey Lucy]

Catalina, thanks for your help and suggestions. I just figured it out and it was staring me right in the face!!! I think I have been looking at this database too long. It's very massive and complex and I've got almost 4 months worth of work into it. Whew.

Here's the answer: On the OnClick event of the button, my Where condition is incorrect. See that? For the new form it needs to be where [Addr] = Forms![FRM-All Property Offers Only]![Addr]

Duh on me! Thank you again for your help!!!!

 

[Catalina]

You're welcome, although I really didn't do anything to help.

I'm glad you found the problem.

Catalina

 

[Hey Lucy]

I am grateful for the fact that you were willing to try, though.