Continuous Form with command buttons
I am having trouble creating these buttons the way I have described. I should be okay once I get the buttons captioned correctly.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I'm not sure why, but the command button is only enable on the first row of the continuous form and disabled on all other rows. I have another application that functions the same way and there are no issues with it, yet I cannot find any differences in the command buttons. In fact, I copied it from one form to the other.
Is this a common issue? How do I fix it?
This works great, however I need to put some control on the button so entries are not duplicated on multiple button presses.
Here is what I have tried so far:
I have the INVOICE_ENTRY command in the continuous for run the query and disable using this code:
Private Sub INVOICE_ENTRY_Click()
Me.INVOICE_ENTRY.Enabled = False
This works, but since a continuous form it disables all the buttons. can't have that.
I then tried adding another step by having the INVOICE_ENTRY command open an unbound single form, setting default values to the original INVOICE_APPROVER form, and placing a ADD_ENTRY button in the Footer.
I used the same code as above adapted for this new form. This works as well, however when I close the form and click the INVOICE_ENTRY command on the continuous for the ADD_ENTRY command is no longer disabled.
and I know this is a lot of work for something that could just be bound to the original invoice table, however doing it this way is somewhat necessary.
However, when I open this second form up by itself these buttons function as they should.
@AccessMSSQL mentioned that when I open the second form through the command button, this may cause only one record to be displayed so I can't move to next or previous.
The problem is with generating the graph. I'd like to use the form's filter for bounding the graph's data. So records shown in Form1 must be used for the new graph (Graph1 in Form2). Isthere a way to copy the filter to the new form or use the data?
I know that this is explained quite weirdly, but I cannot think of another way at this moment.
etc. sometimes. Button one would have the caption of EFF-01, button two would have the caption of EFF-02, . etc. The names would change per results from a query. All buttons would then have captions.
The form that I am trying to make is to simulate a touchscreen except for now with a mouse cursor. I am not able to assign a caption to my buttons. I have made my button names like cmd_Product_1, cmd_Product_2, etc.
In trying to reference my command buttons to assign the captions from my recordset info I made a string variable for cmd_Product_ and an integer variable to append to the end of the name. I believe the variable string name for my command buttons is working OK up until it comes time for me to assign the string to the control. I get a runtime error 91 "object variable notset".
When I click a command button on the form (Unlock) I want it to make the command buttons on the subform to become enabled.
How do I go about changing the properties of a command button on a subform?
TOC: List and combo boxes, Check boxes and option buttons, Command buttons.