Topics Search

Unbound/Bound Forms

Unbound/Bound Forms
Views: 87
I have inherited a database that is used to track product development. It is set-up so that one product has one key(product_id). The bosses have asked to be able to track the changes to the product over the development life cycle. I have created a table with the following fields: product_id, change_id, change_notes, and change_status. I have created a form that holds all of these fields, and two unbound boxes. One of the boxes contains an expression that is fed by the product_id from the open form, and the other (to create a change_id) is created by adding a "C" and a now() after the product_id (product_id & "c" & now()).
Problem: I am having an issue getting the unbound boxes to populate the product_id and change_id field in the actual table when I try and save. I am really at a loss. Have been googling calculated fields and before update for the last couple of hours...
Sponsored Links:

Similar posts...


Why unbound from as Splash Screen??

Why unbound from as Splash Screen?? Icon
Can someone explain why this is? Is it just preference to not have bound forms? Can you not have a splash screen that is bound to anything?

Haven't looked into this too much as I'm pretty novice to the development side of forms and such. Someone mentioned unbound in one of my questions and I just saw a tutorial about creating splash screen and it mentions you should create an unbound form

Why using unbound forms are a bad idea

Why using unbound forms are a bad idea Icon
Unbound forms are forms with no data source, whereas bound forms have one and it’s the default way to bind your form to your tables or queries. Having a data source is the normal way you create Access forms, but it can cause problems no matter how careful you can be:

Datepicker not appearing on Bound Control

Datepicker not appearing on Bound Control Icon
I have two versions of the same form, and one for viewing it once it's created.

Both forms have a textbox called Date, which are identical except for one is Unbound and one is bound to the Date field from a table.

The Datepicker only appears on the Unbound textbox - if I unbind the textbox on the viewing form, it reappears.

Why is this? Is there any way of getting a datepicker to appear on a bound text box, or would I have to use a custom calendar control?

What is a unbound form in Microsoft Access?

What is a unbound form in Microsoft Access? Icon
Basically it is a form that is not bound to any database table or query. You can usually determine if a form (or a control on a form) is bound by looking at its record source property which will either be bound to a Table, Query or SQL String. Also if you look at each control on the form you will find that each control has a Control Source, which is derived from the field names made available in the Record Source. A bound form is easier to create and requires minimal programming (if any). It allows for rapid application development since Microsoft Access is designed to make application development fast and easy. An unbound form on the other hand requires a lot of programming, BUT gives you near total control over how your application is going to work. This in some cases outweighs the numerous benefits offered by bound forms.

Why does my Undo button become active for some changes but not others.

Why does my Undo button become active for some changes but not others. Icon
I have an Undo button on my form that is supposed to become active whenever a change is made. This works fine whenever I change a bound field.

However, I also have unbound fields on the form. Once I change an unbound field, this appears to mess up the UnDo logic as from that point, changing a bound field no longer causes the Undo button to become active.

Ideally, I'd like the UnDo button to work with both bound and unbound fields but at least I'd like to prevent the unbound fields from messing up the UnDo for the bound fields.

Bound vs. unbound controls

Bound vs. unbound controls Icon
What is the difference between bound and unbound controls in MS Access? How do they differ? And when on an MS Access Form in design view, how can we tell if a form is bound or not?

Spacing of Fields on Access2007 forms

Spacing of Fields on Access2007 forms Icon
When creating forms using Access2007, if I draw fields from a query, table, etc. such that it is a bound field, I find it difficult to insert an unbound field between them in the design view.

Played with padding in Properties. Is there a property that keeps those fields together? Looking for a way of "undoing" formatting, inserting new fields, shifting the fields around, and then reinstating WITH the newly inserted unbound field.

subforms in unbound forms

subforms in unbound forms Icon
I have unbound forms name: Project_List, in it there is two subforms bound in a query. Is there a way to link the two subforms, so that when I click a record on the first subforms. it filters a related records.

Let's say in field name: Doc_Name when I click a record from this field, access will filter related date in the 2nd subforms.

unbound text box filter by form on Split Form

unbound text box filter by form on Split Form Icon
I have a split form, with several unbound text boxes, which I would normally use as a filter by form type function. the query has criteria bound to these text boxes.

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.

Call/pass Value from SubForm to MainForm

Call/pass Value from SubForm to MainForm Icon
I would like to insert the value from a bound control on a subform to an UNbound control on a main/Parent form.

e.g., insert value in subform.pos_sts into an UNbound control on MainForm.

Of course the value in the subform control changes as you scroll through records so the value in the UNbound Control on Main/Parent form should change accordingly. I have tried something like =[forms]![SubformNm]![ControlName] in the UNbound control on the Main Form .but was getting #Name error?