Search results

I am sorry but i still dont understand. If Me.Option1 = 1 Then Me.Firstcombo.RowSource = [swimmer details]![forename] Else Me.Firstcombo.RowSource = [stroke1]![stroke] End If Can you help correct my code please.

ok thankyou, where does this code go (its not working in the row source) does this code look ok? "ifMe.option1=1 Then ";"Me.Firstcombo.Rowsource = ""SELECT forename FROM swimmer details""";"Else";"Me.firstcombo.Row source = ""SELECT stroke FROM stroke""";"End if";" "

Thanks Paul but im working with 2 option buttons (either option button one is selected or option box 2 is selected). How would i incorporate this into the code, will i have to use something like if option1 is true then...... else select from table 2?

thanks for the link but i cant download for some reason (something to do with adobe) But i dont currently have any queries for this? looking at your code where would i substitute the names for option 1 and 2 aswell as combobox1? Thanks

hi I have two options above a combobox. If option one is selected i want the combobox's criteria (or row source to be list 1) if option 2 is selected i want it to be list two. These two lists are from 2 seperate tables. I am thinking that i need some code but dont know what the code should be...

ok im not sure if i explained properly. You know the "return value" box what lets you choose 1,5,25,100,5%,25% etc. Well in my form i would like to use a listbox to select or input a number, as in someome my want to find the 5 greatest values, but next time wants 10 greatest values. If this is...

thanks everyone, learning all the time. with regards to the average function, how do i find the average of times? at the minute i am getting 5.25E-02. Wheras i am looking for something like 01:15:09

quick question. In a totals query i have a list of times. Hoe do i use the average function to give me correct average times? It is currently giving me the number 5.25E-02. I am looking for something like 01:15:09 for minutes:seconds:milliseconds

have you any links because i think i need the max function for another question i had too?

I am hoping this is a simple question to ask you; if i have the following data: person event time A.smith A 1.15 A.smith B 1.20 A.smith A 1.10 A.smith B 1.50 A.smith C 1.16 How can i make my query return the quickest time for each event, e.g. so I get: person event time A.smith...

ok thanks for reply, but the help menu of what?

ok i know how to set the criteria of a query to the contents of a taxt/list/combo box from a form. But is there a way i can change the return value of the query from a form, (e.g. returns the freatest value of something) instead of doing it manually and typing in 1 in the Return: box? does this...