Search results

A little stuck Hey, that was very helpful and i think im almost there. I'm just stuck on a few things. I have two tables involved at this point, one called Match and one called Goals. Match - this tracks, which team played which, and on what date Goals - this holds the matchID, the...

Well by no vba i mean no adding and deleting and lots of procedures, etc. I guess a little refresh/set focus/validation, etc, is ok. I'll explain. The system holds football results between two teams. It records which players scored and how many goals they scored. So: combo box 1 : who...

The combo box is: SELECT tblPlayers.Forename & ' ' & tblPlayers.Surname FROM tblClubs INNER JOIN tblPlayers ON tblClubs.Club_ID=tblPlayers.Club_ID WHERE (((tblClubs.Club_ID)=Forms!frmAdd_Result!cboHomeTeams.value)); And the listbox doesnt have a rowsource at the minute. But i want it to...

Guys, im doing a university assignment. The user selects an item from a combo box. I want this item to be added to a listbox - is there a way to do this without using vba code and only using queries and stuff like that ? The item should also be removeable from the listbox if needed. Any ideas ?

Oh Also, how do you clear a combo box. Basically I am doing a system for a sports database. Team A play Team B. Some players score some goals. The user selects the number of goals the team scored. Then they must enter how many goals each indivual player scored. This is done via a combo...

Ok Thanks. That worked. However, i now need to know how to reference it. How do i say i get the value of an item. Lets say my 2-column list box looks like this: Apples 10p Bananas 30p Oranges 50p How do i getthe value 30p or the value Oranges from the...

I am designing a form that is interacting with some data in some tables. I have a combo box, where a user selects what they want. Then the select another value from a combo box next to it. I want to add these two values to a listbox, one value in one column, and one value in another. I have...

AHH.. PLEASE help me .... I really need some help. I am designing a form that is interacting with some data in some tables. I have a combo box, where a user selects what they want. Then the select another value from a combo box next to it. I want to add these two values to a listbox...