Search results

Brilliant, that worked. I don't really know what I did wrong last time. Thanks again for your help and quick response.

I managed to get it working, it was just because I had the 'bolquantity = Me.txtOutletQuantity.Visible' reading the wrong way round. Thanks for your help with that! Now while we're here, how can you make these two combo boxes work. They are both based on a single table. The first combo box...

I tried the msg box and it displayed "None", so I don't know how it's not working when I question if it equals that. Nothing can be entered into the combo box, the combo box just displays the table records, which are fixed.

In fact it was a single form, I just guessed. It said that column0 is the one which I want to test, it said column0 = "none" and column1 is "0". Column 1 was only used to order the records by size.

The combo boxes are 2 columns wide, but only show first column. Maybe thats why it doesn't work...how can you do an if test on just the first column? I presume its continuous.

So far on a form I'm using I haven'tbeen able to use VBA code successfully. I'm not sure why this is happening, maybe there is something wrong with my database? My recent attempt was to get a textbox to appear visible only when "None" was selected on the combobox next to it. The code for this...

Thanks for the reply. I tried that but then it said "Microsoft Office cannot find the object 'SetComboBoxOptions"... Come to think of it, no VBA code I've entered has ever worked on this database, is there something wrong with my settings?

Hi, I was trying to build an access form which is similar to something I've already made on excel. It was an automatic pricing program which works out the cost of a water tank once you enter the dimensions. What I am trying to do is have a combo box which has 2 options, where the two options...

Thanks alot for your help, but whilsed at college I managed to work out that I could enable the control 'sub total', which even when enabled, cannot be edited, so i used this as a way of moving the focus and it works fine :) Ive also sorted the date control after looking at it, for some reason...

Yeah it doesnt work, I tried testing it and it still comes up with cannot disable a control while it has focus

Aha ye that sorted most problems just now when ever you click upon 'quantity' and then click the ordercompleted check box, it says 'cannot disable a control while it has focus' again :o Also I have a problem in the add order details form as I cannot get it to display the current date in the...

Right heres my database Have a look what you can do

I know that but where abouts in the code? where abouts in an if test(if there is one)?

Everything works fine and ive copied and pasted the code into both on current and on click...except when I change a field of a record, and then click on the check box again and it says 'cannot disable a control when in focus' There are no other enabled objects in the subform so obviously it will...

O dear its still not doing much Now the problem is since the focus has moved to this text box, the two fields do not become disabled If I changed the width of the field that i want it to focus on(in preview(datasheet) mode), so that it doesnt show up, does it automatically appear invisible...

Well now more problems since there were no other enabled fields, i had to create one to act as something to set focus upon, i have made the property of the text box to be invisible...but it blatenately ignored it and displayed it any way Also another problem is that now it just disables all the...

Well now more problems since there were no other enabled fields, i had to create one to act as something to set focus upon, i have made the property of the text box to be invisible...but it blatenately ignored it and displayed it any way Also another problem is that now it just disables all the...

The only problem now is that it errors saying 'cannot disable a control while it has focus' based on the field 'Stock ID' which is the first field to appear in the subform so far i have in... Private Sub Form_Current() If Me.OrderCompleted.Value = -1 Then Me.query_subform_subform.Form![Order...

Well thankyou that was helpful and there is an order date and supplier ID but its not them i need to change. The fields that i want to edit are on the subform, and the order completed check box is on the parent form, so i think i may have to type the whole pathline of the object on code builder...

I know what enabled and locked properties do...I just need help in changing two of the fields' enabled properties to false when the 'order completed' button is checked