Search results

Hi all, How do I reload a subform without leaving? Reason being is that I am deleting a record in the after insert event of the form and when I click on another tab/button whatever it comes up with deleted all the way accross. What would be ideal is that when the event is triggered is to...

I have a beforeinsert event on a sub form and am trying to do some validation on it. Basically when a user clicks a value on a combo box within the sub form it hits the code below in the beforeinsert event. However, "Meet" (combo box value) is null when I clicked on No. What am I doing...

Hi, What I want to do is to validate the user's entry in a subform. Example: If the user puts in yes to a question such as "Has the cllient had a meeting?" If the user puts in yes, the next line cannot have no entered. However they may wish to change the first line to a no which is fine...

I am trying to use the code below to put the result into a varible: strSQL = "SELECT COUNT(*) FROM adult_key_pro WHERE adult_key_pro.key_inc_id = 12;" The problem is that the variable has nothing in it when I stop the code using a breakpoint. Any help would be appreciated.