Recent content by tormented

PeterL Not to sure if you've done so already but make sure you "DEBUG" any code before you attemp to make a MDE. Tormented

I am a beginner at Access so if this seems wrong please let me know but it seems to work fine for myself. 1)Review your tab order for your form.(Design View) 2)Create Command Button (CMDCOPYLASTRECORD) on your form. 3)Private Sub CMDCopyLastRecord_Click() SendKeys "{tab}" SendKeys...

I have recently seen in a book that the value of check boxes can be 0,1, and 2. One for unchecked,checked, and greyed. I can not remember exactly what value for each. I will try to get the exact name of the book and page number to help. I will try to post everything by tomorrow . Tormented

CajunCenturion , Many thanks for all your help, everything is working great As you have helped with two problems I will give you two stars. Thank you again. I am quite new to Access and to this site and am glad there are individuals like yourself to help with the "bumps in the road!&quot...

CajunCenturion, Not to sure I follow? Both Westward1 and 2 both pull up lists of whatever Subdivisions is set to. If I cange Subdivisions and then go back to west1 or west2, they now represent the change I have just made to Subs. My problem was that while the "list" for west1 or 2...

CajunCenturion, Here are the codes I am using to requery the combo boxes! comboA=Westwardsignals1 comboB=Westwardsignals2 ComboC=Subdivisions Private Sub westwardSignals1_enter() If Not IsNull([Subdivisions]) And [Subdivisions] <> &quot;&quot; Then WestwardSignals1.RowSource = &quot;SELECT...

CajunCenturion Every combo requery's it's data. I'm sorry I forgot to mention that every combo has it's own code as shown above. In my rush to get back to you I forgot to put the equation for ComboB as well. It is exactly the same as ComboA's. Actually there are about 10 combos but for...

here it is As well I thought you should know that if i go back and delete comboB then Everything works fine! It will not if there is a value already there If Not IsNull([comboC]) And [ComboC] <> &quot;&quot; Then ComboA.RowSource = &quot;SELECT table.feildA, Table.FeildB FROM Table WHERE ((Not...

cajunCentrion Thank you I have given you a star I am having one other problem with this now ComboA and B(rowsource) are controlled by another=ComboC thru a query If comboC= &quot;apples&quot; then ComboA and B show list of only &quot;apples &quot; If comboC= &quot;oranges&quot; then...

I forgot to mention ComboB.listindex= ComboA.listindex+1 Gives the error &quot;Improper use of Listindex property&quot; So I changed the code to ComboB=ComboA.listindex +1 Thanks

Finally got back to the computer. This works to a point. Instead of the number that I require ie &quot;14.4&quot; in the text of ComboB I now get the listindex number of ComboA+1 into the text of ComboB Is there a way you can reference the Listindex but insert the text that the List index is...

CajunCenturion, I afraid I newer to Access. Can you explain about .listindex a bit more as anything I've read on it isn't to clear. As well as for securing the corresponding value. I will be away from computer for a while so I will check back tonight. Thanks for any help in advance. Tormented

Ken Thanks for your reply, Sorry I should have given a little more info. Both ComboA and ComboB get ther values from TableA,FeildA Feild A has records which are numbers, which are not even. IE 12.2, 14.4, 17.9, 23.6, so on and so on If comboA=12.2 then I would like ComboB to get the...

I have two combo boxes. ComboA and ComboB. I would like to have comboB default to the NEXT greater number than what was selected in comboA. Any Suggestions?

To Mac, Thank-you, thank-you and thank-you. A star for you!!!!!! Much appreciated for the help. I hope someday I will be able to return the favor.[2thumbsup] To Jjob, Thank-you for your input as well!! Thanks Tormented