Add Data from Unbound Text Boxes to a Table
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a form that has no controls source with unbound text boxes that are populated when I place a corresponding code in a text box then hit enter.
Most of the text boxes are just to view data but one of them I want to edit the source field in the table if I press a button. The caveat is I can not have any of the fields bound it all needs to be done via VBA.
After this is done, I will like the record source to be changed to another table so I can add some data to the ones displayed by the search criteria before adding to the new record source.
=sum(iif([CCTVOverdue] = "On Time",1,0))
CCTVOverdue is the name of the unbound text box - can anyone let me know what I am doing wrong here?
What do you want to do: Add a bound text box, Add an unbound text box, Add a calculated text box, Understand text box properties.
I have form with lots of information based on a master table. One on tab control I have setup a number of unbound text boxes with IIf expressions, these return values. These values are summed and another unbound text box creates another value - "Risk" i.e. High, Moderate or Low.
These are all unbound text boxes and the values are only there to run the expression to determine risk. This is the value I want stored in my master table. I have created a text field in my master table but I want the form to be able to take the risk value form teh unbound text box and drop that into the table under "Risk".
This will be unique for each master record on this form and will change depending on changes in parameters selected within the table.
I want to keep these text boxes unbound. I know I can do this if I used a dummy table but I don't want to go that route if at all possible
My problem is that I cannot seem to get the mouse to focus on the unbound text boxes on this split form. when I click in the unbound filter by form text box, the focus immediately moves to the first text box that is bound to data on the form.
Then I will try recreating my split form in a different way. if it is a problem, If perhaps a split form cannot have any unbound data entry controls on it, then I could create a form with the search criteria on, and keep the forms separate. If I was to do this, though I would like to 'dock' this form at the top of the window, and then have the split form 'dock' underneath, as if there was an application level window splitter control. Another option might be to put the filter by form text boxes in the ribbon, and I have added some stuff here, but I am unsure how I might refer to the control in a query criteria.
I have a main form that is linked direct to a table. On the main form I have a unbound text box. What I am hoping to achieve if possible is to have data entered in to the unbound text box be added in to a second table on click of a button. The unbound text box is name "txtcomments" and the table name is named "Comments" I would also like to auto add in the date the comment was added which would be the data of today! Both the comment and date fields are in the table, I just don't know how to pass the data with VBA
The text boxes get their value from two other fields [Quantity] and [Price] the text boxes are of course the total. At the bottom of the form I've been trying to add up all of the text boxes for a grand total.
However if any of the 25 text boxes are empty the total will not add and I'll just get a blank. If all 25 contain data, then everything works fine. I've already checked and all the text boxes are the same data time - Currency.