Recent content by bigbadbess24

Thanks for catching the typo on Dates. But that does not solve my problem at all, I am still getting blanks in my Player Full Name pull down.

Another question I have a text box followed by three drop down boxes (Combo boxes). After I Input a number into the text box I have a query that runs to give me information on that number. SELECT [tbl Matches].Date, [tbl Matches].[Guest Team], [tbl Matches].[Home Team] FROM [tbl Matches] WHERE...

I figure it out. I need to add 0";1":0" and 0";0";1" to the column widths. Thanks for your help

I have a text box followed by three drop down boxes (Combo boxes). After I Inpute a number into the text box I have a query that runs to give me information on that number. SELECT [tbl Matches].Date, [tbl Matches].[Guest Team], [tbl Matches].[Home Team] FROM [tbl Matches] WHERE ((([tbl...

Thats funny, I looked back at the old post and you did say that! I really mess that up. I think originally I put the code in for both combo boxes and that made thing diffcult. Once again thanks.

I figured it out. I had to put the expression in the school combo box. I put it under the Afterupdate and I put me.combobox(playersbox).requery Basically means to update my players box after I change the school box. Thanks for all your help!!

sorry I do not know whatelse to say

then am i doing something on my end wrong?

Sorry I know SD has no players, all school will eventually have 20 players for 6 schools I was using them for a test When I look at you DB and I open up the form its default to SD as the school. When I drop the school field it will not let me choose a school, its actually locked. When I go to...

Yes I am adding this information to a table. I pulling the School from one table and putting it into another table and the same for players and position. I looked at your db and even if I do not click on next record, Lets say I open the form for the first time and I put in one school (HT) and...

First step, select a school, then select a player (the query gives me all the players in that school that I selected) and games won and position. When you click on next record do the same procedure. But when I go to next record I select a different school, if gives me the players from the last...

Thank you for you quick response and all your help I saw what you did with the expressions. However it is doing the same thing. This time though, when I go back and select a different school, it makes it blank and I have to select it again. But when I select the select it again and go to the...

Here is the database. Thanks

The school combo box gets infomation from a table. The players combo box gets information from the query And yes, when I put in the expression me.comboboxname.requery I put in the combobox name (combo17) I have in place of yours.

Thank you for your quick response, but that did not work. I put the expression for both combo boxes and information did not update.