how do i add a new field from a table to a form

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

Guest

I have a new field in my Table that i need in my form
there are no queries
the new field does not show up in my field list.
i have tried to add a text box and set the properties data control source to
it but it does not show up in that list either.
my form is a combination of two tables, one table for entry and records the
other is a premade library that does not change.
the feild i need to add to the form is in the data entry table.
i have look at many similar questions here that all had solutions, but none
of them have provided a solution for me.
am i missing something? or do i need to make a whole new form?
 
You say that there are no queries, but if your form is based on two tables,
then it's based on a query that relates those two tables. Open the form in
design view, open the Properties window, and click on Data tab. What is in
the RecordSource property? Assuming that it's a query, you will need to add
the new field to that query so that your form can see it.
 
If i open the properties window on the data tab i get nothing, just a blank
grey window screen labled section detail.

before i created my form my tables where linked many to one. i made the
relationship so based off a text i enter in one the form would look up and
display information from the other.

and when i made the form i clicked new form wizard but did not choose a data
source on that tab and went to the next tab.
 
Hi, Damon.

Just in case Ken does not get back to you right away, I thought I'd answer
your question.

In form design view, there is a small gray square on the top left of the
window just below the title bar. Right click on it (it will then display a
smaller black square inside), and choose Properties to display the form
properties. The form is based on the query specified in the Record Source
property. Open this query, add your new field, and it will be available to
place on your form.

Sprinks
 
That was it
Thank you very much

Sprinks said:
Hi, Damon.

Just in case Ken does not get back to you right away, I thought I'd answer
your question.

In form design view, there is a small gray square on the top left of the
window just below the title bar. Right click on it (it will then display a
smaller black square inside), and choose Properties to display the form
properties. The form is based on the query specified in the Record Source
property. Open this query, add your new field, and it will be available to
place on your form.

Sprinks
Click to expand...
 
Back
Top