combo box selection

[sammy16]

I hope this makes sense and someone can help!

I have a combo box on a form where I can select a project number. I then wish to base a query on the selected project number to tell me the total project time entered in by each team member. The problem I have is that the project numbers are entered in free text and there are spaces\description eg TCP-29 or 29 or TCP - 29, in some of the numbers. I want to be able to gather the information for the entire project.

I am currently usine this code in the query:

Like [Forms]![frmTeamLeader]![cboProject]
but it is only picking up the specific value you click on.

I know the best solution is to not make the project number free text but I have no control over that side of the data collection.

Can anyone help?

 

[Bat17]

Is the number itself enough to identify the records as you could strip that from the rest of the garbage.

Peter

 

[sammy16]

It should be.

 

[Bat17]

Have a look at this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=73785&highlight=integer

That will show you how to just get at the numbers. I would use that in you combo query to give them just the number list to chose from. Then in your query you will need to add a column to strip the numbers as well. Use the criteria in this new column.

HTH

Peter

 

[sammy16]

I'm sorry I'm not sure where you mean by the query combo.
I choose a Team Leader from a combo box fisrt and then the project list is based on the team leader selected.
Should I call the code in the after update event of the Team Leader combo box?

 

[Bat17]

you should be able to put the code in your project number combo SQL, so that you will only return the number element of the Project number, you will probably want to look at setting the source to "unique values" as well.

Peter

 

[maxmangion]

Like [Forms]![frmTeamLeader]![cboProject]

try Like "*" & [Forms]![frmTeamLeader]![cboProject] & "*"