New table field not showing up as a Control Source

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

Guest

How can I get the text box field on my form to populate my new column in my
backend table?

I went into Design View for my table and added a new field that I want to be
populated from my form.

When I added the new text box to my form, it showed up as Unbound. I
clicked on Properties for that particular text box and went to select the
Control Source from the drop down menu - however my new table field did not
show up in the drop down.

How can I get the text box field on my form to populate my new column in my
backend table?

Thanks for your help,

Matt
 
Is your table the record source of that form? Most likely your form is
using a query as the record source. You'll have to add the new field to the
query first, then to your form.
 
Thanks, Rick.
I did not create the database, so I was assuming that the table was the
record source because it had the same fields as the form. I'll check the
queries.
Thanks again, Rick. I appreciate the help.

Matt
 
In the form Design View goto the form's Properties Box > Data and check
the Record Source for the name of the query/able. I suspect that Rick's right!


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top