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.

AfterUpdate issue

AfterUpdate issue Icon
In my form I am trying to change a bound field with the value of an unbound field that occurs before it on the form so this new value shows up in the table for that field. The unbound field contains a number from a field on the previous record from the table, and the next field, the bound field, is to get that value. I used the AfterUpdate event in the unbound field property, where unbound field = the bound field. I tried this with the control property, then tried using the AfterUpdate event for the form, and no value appears in the bound field and doesn't show up in the table. Both these fields are in a subform. I used the "Me." prefix for both fields and that doesn't work. Probably some minor thing I am not seeing

Force SQL update on a bound form

Force SQL update on a bound form Icon
I am trying to force a bound form to execute an SQL update (and a few housekeeping tasks) before I navigate to the next record, even if I am only updating an unbound control (listbox). The beforeUpdate event only seems to fire if I change one of the bound controls on the form. I have to have both bound and unbound controls (I think) because there is a many-to-many relationship between the bound record and the items in the listbox (so I am using a collection table).

If anyone could provide some information on a possible solution, or some better definition on the event order when the form's navigation buttons are clicked, I would be greatful. I am using Access

sum in form footer

sum in form footer Icon
I have this problem and I cant figure it out how many times I have tried it myself.

I have this subform, and it has 4 textbox: three that is bound and the one that is unbound form.

when I do calculations in the bound textbox, I can successfully arrive at the sum of textbox3 but when I sum the fourth unbound textbox, it give an error inside the textbox.

Does it mean I cannot make a summation of an UNBOUND textbox

Updating default value of bound form from an unbound text box

Updating default value of bound form from an unbound text box Icon
I have a bound form that I am using to add new records. At the top of my form is an unbound text box ([txtInitials]) that the user will type into. I want to take that value and have it be the default value for one of the bound text boxes ([CheckedInBy]).

I have set the default value of [CheckedInBy] to be =[Forms]![Incoming]![txtInitials]. This does the trick for all of my records except the first one on the form since that blank line is uploaded before the user types into [txtInitials].

I have also tried the code below in hopes of refreshing the [CheckedInBy] text box to contain the default value I have designated for it...

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?