New field on developed form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

How do you create a new field on an already developed form?Do you first
create the field in a table then go to form design and insert a field through
there?

Thanks
 
jk said:
Hi,

How do you create a new field on an already developed form?Do you
first create the field in a table then go to form design and insert a
field through there?

Thanks
Click to expand...

You got it. The only thing to watch for is the RecordSource of your form might
not pick it up automatically. Wizard created forms where you selected the
fields you want on the form will have a RecordSource that is a SQL statement
like...

SELECT Field1, Field2, ... FROM TableName

A SQL statement that explicitly names the fields to include will not include any
new fields you add to the table until you modify the statement to include them.
If the RecordSource is simply the name of the table, then new fields added to
the table will immediately be available to the form. As will a SQL Statement
like...

SELECT * FROM TableName
 
Thanks Rick,

Ok, you first create the field in the table....like for example [Account
number]..then you go to the already developed form in design view and place a
text box on the form.Now, how do you associate that new text box to the
[Account number] field in the table so when data is entered in the form, it
goes to that field?

Thanks
 
jk said:
Thanks Rick,

Ok, you first create the field in the table....like for example
[Account number]..then you go to the already developed form in design
view and place a text box on the form.Now, how do you associate that
new text box to the [Account number] field in the table so when data
is entered in the form, it goes to that field?
Click to expand...

You skipped the step I was describing in my first reply. You (might) have
to alter the RecordSource of the form first to add the new field to it.

In the toolbar while in design view is a button that will display the field
list. This is a list of all of the available fields in the form's
RecordSource. Look at that and see if the new field is shown. If it is you
can simply drag and drop it on the form and Access will create a control
already bound to that field. If it is not listed then you need to modify
the RecordSource so that it is.
 
Thanks Rick,

I will add the field to the table and follow the steps to review the sql
statements...if not there, then include the new field as a select
statement.......thanks

Rick Brandt said:
jk said:
Thanks Rick,

Ok, you first create the field in the table....like for example
[Account number]..then you go to the already developed form in design
view and place a text box on the form.Now, how do you associate that
new text box to the [Account number] field in the table so when data
is entered in the form, it goes to that field?
Click to expand...

You skipped the step I was describing in my first reply. You (might) have
to alter the RecordSource of the form first to add the new field to it.

In the toolbar while in design view is a button that will display the field
list. This is a list of all of the available fields in the form's
RecordSource. Look at that and see if the new field is shown. If it is you
can simply drag and drop it on the form and Access will create a control
already bound to that field. If it is not listed then you need to modify
the RecordSource so that it is.
Click to expand...
 
Back
Top