Adding text field to form issue, control source not listed in property sheet

[Noek]

I've created a form based on a table. Everything works fine. Now I am adding a text field to the table and form, I create a text field on the form but the selection for the control source in the property sheet isn't listed. If I just name the text box the name of the field on the table, I get an error. I am new to Access and I have searched everything and cannot find a fix. If I delete the whole form and start over, then I am sure it will work, I just can't seem to add it after its been created.

Thanks in advance

[Micron]

First, your form has to be based on a domain (query or table) or else you will not find any fields from the target table listed in the control source list. Second, I generally would not use a table for a form or report source, I'd use a query that only loads the records needed for that form, which is often not the whole table. So did you set the form recordsource first?

[jojowhite]

you can add additional bound control to the form by going in Design View of your form.




then on Ribbon->Add Existing Fields
and Hold and Drag the Field you need inside your form.

[Noek]

I created the table first, then I used the form wizard to create the form. Now I’m trying to add additonal fields to the table and then to the form as well.

Should I create a query based off of the table instead?

[Micron]

IMO a query is the better way to go, but not having done that probably isn't at play here. If you added a table field and based the form recordsource on that table, the field should be available in the field list for the added control (we're talking about a textbox, yes?). However, you may have to close and re-open that form first; can't recall. If you have done that and the field is not available, then I'm not sure what to say, except that if you want to copy and zip your db and upload it, we can take a look. See "how to attach files" at the top of the web page.

Note - my comments about using a query are mostly related to when a table has, or may come to have, tens or hundreds of thousands of records (or less if there's many, many fields) because by basing a form on a table, you will load all of those records when the form opens, when you may only need a small number of records to be displayed. So, I typically based forms and reports on queries because it's easy to a) filter the records to what is needed at the time; b) select only the required fields for the form's purpose, and c) if a field is in the table but not in the query it's easier to add that field to a query because it will never cause relationship issues with other tables.
Note 2 - I realize that one can filter a form, but I once asked a M$ engineer if all the records are loaded, then filtered, or filtered then loaded - and never got an answer. Either way, I suspect a query is faster as it Selects rather than filters.

[Welshgasman]

I must admit that I just add the control and then select the source from the Data tab.
As long as the field is in the source, be it a query or table, that should work.

I always name my controls differently from the source txtFName, cboDateReceived, etc.

With a 'picture worth a thousand words' saying, look here

[mike60smart]

Hi
Can you upload a copy of the database?