Search results

What about code like this. I go it from another DB but not sure if it would work. Sub Combo1_AfterUpdate() Dim db as DAO.Database, sSQL as String Set db = CurrentDb DoCmd.SetWarnings False sSQL = "UPDATE tblYourTable SET Col1 = '" & Me.Combo1 & "';" db.Execute sSQL...

I have looked at this and I see what you are trying to get me todo. But I have 3 of these combo boxes and once I select an entry it is the same for all the next entries. With what you are doing is different.

"You can't assign a value to this Object." this is a message I get when first trying to enter data into a form. But its a little strange. There is the form and the subform. The subform can work all the work all the nessary functions of the form. The main form is only for visual effect and ease...

Do you mean change the hidden text box to a unhidden combo box and have no combo box in the header. If I did this then I would have to select a value for every continuation of the form and this is what I'm trying to avoid. Unless I' not understanding you solution. Thanks

You mean set the control source of the hidden text box to the field in the table I want it stored in. OK if I do that what code do I entry in the afterupdate to capture the selected value from the header's combo box and store it in the tables field. Thanks

Where is this option, I can't seam to find it. NO, wait I just found it. That was simple enough. Realy should have taught of that my self. Thanks

I have a Undound combo box in the form header. The form is set to a Continuous Form and each continuation of the form needs to store the selected value of the header conbo box. So I put a hidden textbox in the detail section to capture the combo box selected value. And it does but I want this...

I'm trying to load my form blank also. The difference is I do not want to edit data just add new data. But the form which is a Continuous Forms opens with all the data. What is the simplest way to stop this from happening. Thanks

I supose this part should stay the same; DoCmd.RunCommand acCmdSaveRecord And because it's taking the info from a combobox Column() will come into it.

I'm going to keep trying to get this to work but so far I've had no success. Are you sure this works. The hidden field does not seam to capture the Value to store. OK I just got that to work, not that I'm going to use it for calculated fields. But I'm wondering will the same system work for...

Sorry Bob, just not sure what your saying here. So the VATAmount should stay the same with the =[AmountExVAT]*[VATRateID].[Column](2) in the control source. Then I add a new test box to the form that is hidden and call it VATAmountHidden. Set its control source to...

Thanks Wayne, I using Access 2007. Yes I know .Column starts at 0. But if you want you can help with my next issue. Fields calculated in form are not stored in the table? I have 2 fields that are calculated in the form VAT Amount and Total. Everything else is stored but not these. Now I know...

Here it is. Sorry about the mess of it but I'm only starting out. OK sorry I solved that problem. You were right, the problem was with all my choping and changing I changed VATRate to VATRateID and did not realise it. Thanks for all you help on that one. I still have the header problem, but I...

what version should I upload it in?

should the control name and field name for the combo box be different also.

OK I tried that and no success. Just to let you know that if I set the third column in the combo box to bound then it works. So does that not mean that i have everything set ok just doing something wrong with the expression when third column is not bound.

But it does not work then. Am I doing some thing else wrong so. Is this valid code for doing the calculation. =[Forms]![VatSub].[AmountExVAT]*[Forms]![VatSub].[VATRate].[Column](2) Multiply a textbox AmountExVAT by the value in the third column in the combo box VATRate. Thanks

Hi, in this forum already I have being given an solution to a problem and it should work but [] brackets keep appearing in the expression. Here is the expression. =Forms![VatSub].[AmountExVAT]*Forms![VatSub].[VATRate].Column(2) But it keeps reverting to this...

Sorry mate, I'm greatful for your help but I'm not sure what your asking me to do with this info. Could you elaborate onit a little. Where does this go, Me.YourTextBoxNameHere = Me.YourComboBoxNameHere + Me.YourComboboxNameHere.Column(1) + Me.YourComboBoxNameHere.Column(2) And if I add...

If I have a text box on the form that's value is equal to =[OtherTextBox]* column 3 of a combo box wher colum 3 is Unbound it should read... Me.YourTextBoxNameHere = [OtherTextBox] * Me.YourComboBoxNameHere.Column(2) Am I right Thanks, for your help.