Search results

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.

I have a form with two drop downs (combo box) School and Players. The first drop down I select a school. After I select the school, I go to the next drop down (combo box) and select the players I want. When I go to the second combo box (players) its has a query that runs for me. It takes...

This is what I have now. I need something to link it to the item. My other column is Item Number. UPDATE tblDescription SET tblDescription.[Printed Recipt] = "X" WHERE (((tblDescription.[Printed Recipt])=[Forms]![frmPaddleWinner]![Paid]));

I want to create a form that will update a table. I have two columns, an item number and a paid column. On the form I want to plug in the item number and then I want to hit ok and it will find that item number and put a value (for example "X") in the paid column. I have tried running an update...

Yes I understand that. So that is why I am asking is there a way to doing that

I am not sure if this is place to put this. I am running an auction. I have a report that runs from a table. To get this report I run a form that I plug in the paddle number and prints out their receipt with all the items they won. Sometimes they will come up and want to pay each item...