Search results

Round(f.Text138, 2)

yeah..that too

put single quotes around strings? outside of the double quotes?

is it just the number yout need to increment? say you had 15 rows in the table, you'd want the textbox to show 16? why not use =Count+1 i suppose you could open a recordset and loop through gathering the names and adding them to a string. then just add the string to the textbox.

or just have a loop on the splash screen to see if the form has loaded

your putting the text onto another form? then use Forms!"yourformname"!"destinationtextbox" = Me.txtArea

hmm..how do you intend to save it? inline SQL? a query? setting the name to a text box? On the After_Update of the combo box put Me.txtbox = Me.combobox.column(0) that will assign the name of whatever it is to the text box. hopefully that will let you expand on your solution.

cant you use a recordset to find the number of records in a table using Count() then increment this value. alternatively use a combo box that has a MAX statement as a row source then just reference this value and increment it?

every time i post on here someone always says something better :P

debug is where you insert breakpoints in your code to "step" through it and find what is going on behind the scenes. That way you can see how the code is executed and if it doing what you want it to do

if the sub form is bound you wont be able to assign any values to the fields in it,,,i dont think. Cant you use the OpenArgs to pass in the ID? DoCmd.OpenForm stDocName, , , , , , ValueOFIDtopassIn

ill assume that the report is bound to a table? and the checkboxes are based on yes/no fields? (big assumption i know) then a select statement would give you the number of checked boxes e.g. SELECT * WHERE check = yes and the total value would be something like SELECT * WHERE check = yes OR No

have you debugged it to see what its doing wrong? where is it breaking? is it looping at all?

im still stuck on this. I tried setting the focus to another textbox then on the focus of that moving it away to my target text box..to no avail. :(

works though

if i remember correctly u were using 16775639 as the color code? .BackColor = "16775639" works fine for me...horrible color though :P

use combo.column(0) for the first column in a combo box to return its value

i answered you yesterday after "creating some code" for you to change the background. If the color is one you created and put manually into the pallate then it may not register on his PC but im unsure. Cant you just use onbe thats already stored...like cyan?

havent had a proper look but ive added a bit to your "temp" Sub to show you how i would do it. Also changed the rowsource of your combo box to return the table names. have a look at the code. This shows how to build the SQL statement based on user options. (also changed the field names to...

use .Text instead of value