Add a field to table, conrol to form

[Mommio2]

Hi,
I have a database that has been working just fine until now. I needed
to add a field to the table and then connect it to a yes/no box on a form.
I got it added to the table successfully, but now I am stuck. I added the
box to the form, but the table field is not in the drop-down list for the
control source when I try to assign it. Could someone please tell me the
steps for connecting the box on the form to the new field on the table?
THANKS!!!

 

[Rui]

you have carried out the correct steps. Since the field is still not
appearing on the drop down list, this tells me that the data source of the
form is based on a Select statement or a query.

Just edit the data source of the form and add the extra field there.

Hope this helps
Rui

 

[John W. Vinson]

Hi,
I have a database that has been working just fine until now. I needed
to add a field to the table and then connect it to a yes/no box on a form.
I got it added to the table successfully, but now I am stuck. I added the
box to the form, but the table field is not in the drop-down list for the
control source when I try to assign it. Could someone please tell me the
steps for connecting the box on the form to the new field on the table?
THANKS!!!

Open the Form in design view; view its Properties. Select the ... icon by the
Recordsource property; a query design window displaying the form's
Recordsource query will open.

Add the new field to the query. Close the window and accept Access' offer to
save the new SQL. The new field will now be available.

 

[Mommio2]

Thanks you so much! That worked!

Open the Form in design view; view its Properties. Select the ... icon by
the
Recordsource property; a query design window displaying the form's
Recordsource query will open.

Add the new field to the query. Close the window and accept Access' offer
to
save the new SQL. The new field will now be available.

 

[Mommio2]

Thanks a bunch! It worked!

you have carried out the correct steps. Since the field is still not
appearing on the drop down list, this tells me that the data source of the
form is based on a Select statement or a query.

Just edit the data source of the form and add the extra field there.

Hope this helps
Rui