Disabled command button doesnt work after saving the record in a form

[irslan rafique]

Hi,
I have a form based on query.
I have 2 portions to enter the data. Normally requires only one portion so its cool. I created Next button in 1st portion to go to 2nd portion. All the fields and command buttons are invisible in 2nd portion but get visible when i press next button at first portion.
Like:
I enter data in 1st portion...press Next
all the fields and buttons of 2nd portion become visible. I enter data and press end.
Press save button and in save button i am making 2nd portion invisible and Next button of 1st portion revisible.
But it runs only first time. 2nd time Next button of 2nd portion keep disabled
The code I used:
[For field: Me.field.Invisible=True/False
For Command btn: Me.Command.Enabled=False/True
and Me.Command.Invisible=False/True]
Please help me coz it doesn't work after pressing save button.

Thanks in advance

[Seth Schrock]

Please copy and paste your code (using the [CODE/] button) exactly as it is in your project. It is impossible to see what is wrong with what you have posted. For example, above you are using the "invisible" property of the controls. There is no such thing. It is called the "visible" property that you set to true or false. If you really did have

Me.control_name.Invisible = True

then your program wouldn't even run the first time. You would get an error. So we need to see exactly have you have.

By the way, you don't need to make the button both disabled and invisible/enabled and visible. Just make it visible/invisible and that will control the user's ability to click on it.

[irslan rafique]

Sorry for being not so clear.
Please check the following:

First Next Button:

Me.Command208.Enabled = True
Me.Command147.Enabled = False
Me.Consignee_ID_2.Visible = True

Save Button:

DoCmd.RunCommand acCmdSave
DoCmd.GoToRecord , , acNewRec
 
Me.Command208.Enabled = False
Me.Command147.Enabled = True
Me.Consignee_ID_2.Visible = False
 

Command 147 = 1st Next button
Command 208 = 2nd Next button

[irslan rafique]

The fields of 2nd portion and command buttons have been set visible=no

[Seth Schrock]

Where has the fields of 2nd portion and command buttons been set to visible = No? In the form properties?

[irslan rafique]

they are set visible = no individually in their own properties.

[Seth Schrock]

You mention both a 2nd Next button and a Save button. Are they the same thing? Based on the code provided, everything looks like it should work, which makes me think that there is some other code that is affecting it.

[irslan rafique]

ye they both next button are same things. If i change 2nd Next button to End button with same code...problem is still there i.e. they do not work after pressing save button

[twinnyfo]

irslan,

On this forum, we also like to encourage our posters to learn and understand basic principles about database design.

Your code reminds me how important it is to have viable and meaningful naming conventions for your controls. Although your code will eventually work once we identify the problem with your code, it is a standard practice to identify your controls so that others can identify what they are based on the naming convention.

For example, instead of

Command147
Command208

for your command buttons, perhaps:

cmdNext
cmdSave

That allows others (e.g. "us") to quickly identify the type of control ("cmd" = Command Button) and what that control is used for ("Save" must mean that this command button saves something).

When we are only talking about two controls, it's easy to keep track of, but once you get into complex projects and forms, the small amount of extra time spent utilizing a good naming convention can save countless hours of headaches.

As I said, you code will work with just about whatever name you give your controls (aside from reserved words/functions)--we still have to help you figure your problem out--but, it is best to think about even the smallest aspects of your project design.