Bounding Fields

[Guest]

I created a form and ended up adding new fields to the form after it was
created. How do I go about bounding the new fields that I added to the form?

Thx

JD

 

[Jeff Boyce]

Not sure you and I mean the same thing by "bounding".

Are you saying that you added new controls on a form, but NOT on the
underlying table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

It's easier to put the steps from the begining, so you might have done few of
the steps.

To add new fields to a form that is bound to a table:

1. Add the fields to the table that the form is based on

2. Open the form in design view, open the form properties and view the
Record Source of the form, if only the name of the table is written there you
can continue to the next stage, if it has a select statement you need to add
the new fields to the RecordSource of the form, but this time specify all the
fields, incase you'll want to add new fields again you'll be able to skip
this stage.
Locate the cursor in the RecordSource, you'll see on the right a button with
three dots, press it and you will see the SQL of the form.

Select TableName.* From TableName

3. Add the Text Boxes to the form, open the properties of the text box, one
of them called ControlSource, locate the cursor in it and you'll see that
it's a combo where you can select a field from the table, select the new
fields.

4. Save, Close, Run the form and I hope it will work

 

[Guest]

The new fields are not bound to a table. Basically in essence I created a
drop down box. I want default information to come up when I pull the
applicable menu item from the drop down box. All the fields that I created on
the form say "unbound" and they do not have a control source.

 

[Guest]

Im having a little trouble finding the record source box. Do you mean click
on the field that I created in the properties menu and than look for it?

Also I do have the form bound to a table. But I have another table which I
want to bound the field to. Can you only bound one table to one form for all
the fields on the form?

In essence I created a drop down box (which I want to bound to a table).
When the drop down option is selected I want all the default information to
come up in applicable fields.

 

[Guest]

Open the form in design view, press (Alt + Enter) and that should open the
Properties dialog box, press on the left top corner of the form to display
the properties of the form, one of the properties called "RecordSource",
locate the cursor in it, on the right there will be a button with three dots,
press it and you'll move to the RecordSource (SQL) of the form