Cdogg
01-05-2002, 12:31 PM
After I enter a name into combobox. I ran a querry after update to get different infomation. Is there anyway I can put the results into textboxes.
Thank you for your help
Thank you for your help
|
View Full Version : Putting results of querry into textboxes Cdogg 01-05-2002, 12:31 PM After I enter a name into combobox. I ran a querry after update to get different infomation. Is there anyway I can put the results into textboxes. Thank you for your help jwindon 01-05-2002, 02:52 PM Need just a little more information. Jack Cowley 01-05-2002, 03:38 PM Base another form on your query. Open the form in the After Update event of your combo box instead of running the query. Cdogg 01-05-2002, 03:59 PM In my form I have combobox that I enter a Last name and run a querry.The information I get I put into text boxes. I would to run a querry using the using the last name as I lose focus that would total numbers for all the family members and put the numbers into text boxes. Then I want to total them. I don't want to uae another form and I don't want it in a table view. Jack Cowley 01-05-2002, 04:22 PM I am a little unclear as to exactly what you want to do but the DCount function may be of some use to you. Search help for DCount for more information. Another choice might be to change the Record Source of the form to the query in question.... Cdogg 01-06-2002, 06:16 AM I ran a querry using the last name of a family member to get to there first name and there numbers for the day. I would like to see the results on my form. Then I would like to total them and put that number in a textbox I don't know if I can do this. If I put the first name and the numbers in a list box can I total the column with the numbers and put the results in a textbox. If I can do this how do I total a column. Jack Cowley 01-06-2002, 07:45 AM When you say 'get to there first name and there numbers for the day' are you talking about fields in a record with numbers or do you have multiple numbers in a field? You can display the results of your query in a subform on your main form. If the numbers you want to total are in separate fields then code like this as the Control Source for an unbound text box will give you your total: = Field1 + Field2 + Field3 etc... If your numbers are all in one field then you will need to write code to separate the numbers and add them. Cdogg 01-06-2002, 08:54 AM I have a table the following field names LastName , FirstName , Kids. , Numbers , Date. The LastName and FirstName are one of the adults I ran a Querry to find any body with the LastName and FirstName on a date and to list there kids and there numbers for the day. I would like to show this in a list box and then I would like to totals the numbers. Jack Cowley 01-06-2002, 09:50 AM From your description I must assume that the field 'Kids' has more than one name in it if there is more than one child in the selected family. I also assume that the numbers that you are talking about are also in the 'Numbers' field. If this is so then you will need to write a procedure to extact the names of the 'Kids' and the 'Numbers', put them into temporary tables so you can see them with List boxes. At the moment I cannot think of another way to accomplish what you want from your description. |