Search results

I am getting variable not defined, with this Form_Subform_Example1.txtbox2 = 3. I am trying point to a textbox on a subform from the main form. It highlights 3. What are some possible solutions or examples?

I am still looking for some help :)

I am not having trouble with the number of rows. I am having trouble with sum total updating.

Yes that works perfectly, my form is much more complex then this one. The image of it is the blueprint of my form. Everything works perfectly except for the sum field not updating, after the value changes the in the total field. It does update if you place your cursor in the total field, and you...

I attached an image of what it looks, except my mines is done through vba for fd1 and fd2. me.total = me.fd1 + me.fd2 The sum field will not recognize there was a change in total field. If I did place my cursor in the total field and type 38, and press enter. Then it will capture the change...

I am just looking for a sample suggestion to try out. Description of Subform (continuous form) The quantity field for each row used to be user enter. Now it is automated. I have a textbox where you enter any number, and a combo box to pick a number. The total field shows calculated value...

Yes, and I have those suggestions in my forum already.

The weird thing on my other access the code is exactly the same except for a different form, and it works perfectly. I have a calculated textbox on the mainform that shows the sum of the subform continuous form. I have tried various methods, and textbox is just not updating at all.

What is the reason for not being able to do Skype?

Nothing is working, and I cant upload the file due to sensitive information.

Do you have skype, June7? It would be easier to show whats going on skype then explaining on here.

Yes I am, June :) Sum is referencing that field.

That's what I did in the sum field, but nothing happens.

I have a text box where you enter a value, and combo box where you select a value. Then I have another text box that show the calculated value for that row. Then below the calculated value, there is another text box that shows the sum of the calculated value per row. Say for example row 1 is 67...

thank you so much :)

I have set the field in the table to single, and 0 decimals. In the form I have applied general number and 0 decimals. What else may I be missing to not show decimals? I do not want the values to be rounded up for example 100/1.5+1 = 67.66666666666667, i just want the text box to show 67 in...

Thank you Cronk, this resolved it :)

The cboOption has several plans called 1, 2, 3, 4, 5. Plan 1 and 2 number must be greater than Example2. The text boxes are just simple fields to compare any two given numbers between the text boxes to check if one is greater or less than the other depending on the plan you select. For example...

cboOption does not contain true or false data. If the Example1 is greater or less than the Example2 than it shows display the one of the following messages "You number must be greater than Example2." or "You number must be less than Example2." I kind of got the code working but it will not move...

I kind of got it working, except the code is stuck on "MsgBox "You number must be greater than Example2.", vbInformation, "Invalid Entry:" it will not move on to the else statement. Dim msg1 As String Dim msg2 As String If Me.cboOption.Column(0) & "1" Or Me.cboOption.Column(0) &...