Adding a field to an existing form

[David]

I have a form that I have created. It refers to six
tables. After the form was created, i noticed that i
needed to and a 3rd field to one of my tables. Table name
categories. the database is seymour and the field name is
brownrec. I want to add a checkbox using this field, but
it's not listed in my Field List and I don't have a query
running this. I'm using this form as a dataentry window.
Any ideas on how i tell this new checkbox that the data is
to go to this table called categories?

 

[Fredg]

David,
If you have a form with 6 tables in it's record source,
then you certainly do have a query as record source, not a table.

Look in the Form's Recordsource property and you will see something like:
"Select Table1.Field1 .. etc."
Click on the property line, then on the button with the 3 dots that will
appear.
The query QBE grid will appear.
Drag the new field from it's table onto the grid.

Check to see if the AddNew navigation button is grayed out.
If it is, the form will NOT be updateable.
If it is not grayed out, save the changes.
The new field will now appear in the FieldList tool button.

 

[David]

-----Original Message-----
David,
If you have a form with 6 tables in it's record source,
then you certainly do have a query as record source, not a table.

Look in the Form's Recordsource property and you will see something like:
"Select Table1.Field1 .. etc."
Click on the property line, then on the button with the 3 dots that will
appear.
The query QBE grid will appear.
Drag the new field from it's table onto the grid.

Check to see if the AddNew navigation button is grayed out.
If it is, the form will NOT be updateable.
If it is not grayed out, save the changes.
The new field will now appear in the FieldList tool button.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.





.
Fred, Thank for the help. Just one more question, how do

i get to the forms Recordsource property?

 

[Fredg]

Open the Form in Design View.
Right-Click on the little square where the top and left side rulers meet.
Select Properties.
Click on the Data tab.
The RecordSource property is the first item.