Recent content by dduffy

That still doesn't work, something I had not thought though. Cheers

I tried that but it didn't work either. I am using the listboxes as eachg one needs to be sourced form different queries and the textboxes don't seem to handle this so well. Cheers

Cheers I will sort it out in a few minutes - just getting rid of security etc etc. Cheers

Perhaps I am going about this the wrong way. I have a form that has 2 subforms, each subform has an options box. When an option is selected in either of the subforms a query reruns and returns a value (being the sum of all items selected) in a list box in the main form. 1 list box for each...

Sorry that was a typo, meant to be if it does not equal 0. I have tried your code both with =0 and <>0 but same thing occurs i.e. if the code is set to =0 and the result in the lstbox is 0 I get the message box (this is correct), so I then select another record in the sunform which causes the...

I have checked properties from the query which are definately values, I can't find any such propertires for the listbox but I have also tried it with different examples and changing the code to = to (say) 47.15 and then also as text &quot;47.15&quot; with no change to the results. I have also...

I keep getting the same true or false result when using if statement with listbox. I have a form, on the form are 3 listbox controls. 1st 2 return result from a query initiated on subforms. The 3rd is to be used for validation. I run a query over the results of Lstcont1 & Lstcont2 to get the...

I now have that sorted, trouble is it seems to think that it is fine and the code is simple enough. It appears that the code is running fie but it does not seem to assess the value in the control as part of the argument. You can see that I am asking to return a message box and then cancel any...

Access 2000 I have not had a lot of experience with VBA which is why I was using the Macros, but I have had to use some code already as I am fast learning the limitations of the macros. Cheers

I don't seem to have that functionality, I will look to install it if possible. Cheers

Hi I am having trouble with validation on exit of a form. I have a form that has 3 controls involved somehow in the validation. Cont1 is and amount being calculated depending on the users selection (using a query) Cont2 is the same as above but over another table Cont3 has a query over it...

I have it all sorted, thanks to your help! Thanks you VERY much Paddyo!!! Cheers

cOOL i HAVE IT ALMOST WORKING NOW oNLY PROBLEM i HAVE IS THAT WHEN i HIT THE 2ND OPTIONS BOX the 1st one stays selected the update does however, update the with the correct flag. If I leave the form it then updates the the checked box (i.e. have both options checked at this stage) to...

I went into the code builder through the mousedown event in the properties page, and them typed in the code but I have only used the field name (with no other reference to form or control or table) the group options box is bound to the field QQRNCLD. I can understand the 1st 2 events but I...

Cool, thanks I have got it sorted. Thanks for all your help. Cheers Brad