T
Tobie
I am making a form that is for personnel issues. The field list for it is
completely different from the form. How do I change that??
completely different from the form. How do I change that??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J Steele
Your question doesn't make sense. WHAT field list is "completely different
from the form"?
from the form"?
R
Rick B
What do you mean? The field list pulls the available fields from the
underlying data source. Is your form based on a query? If so, the fields
in your field list will be the fields in your query.
underlying data source. Is your form based on a query? If so, the fields
in your field list will be the fields in your query.
T
Tobie
ok I mean that the form is Issues by Personnel the field list is Issues
Title. I need to change it to the right field list which is Issues by
Personnel. You have to understand this is my first time working with
Access. I don't understand alot and the book doesn't help at all.
Title. I need to change it to the right field list which is Issues by
Personnel. You have to understand this is my first time working with
Access. I don't understand alot and the book doesn't help at all.
T
Tobie
That I can see no underlying data source. The form is not based on a query.
R
Rick B
If the form is unbound, then there will be nothing in the field list. You
are confusing me.
are confusing me.
T
Tobie
I wish i could just send it to you and you could tell me. it is unbound I am
trying to get it to bind.
trying to get it to bind.
R
Rick B
Then go into the data source, click the drop-down there, and select your
table or query. You may have to re-add all of the controls/fields on your
form or change their data sources as well.
Instead, why don't you just create a brand new form using the Form Wizard
and select your table or query as the data source?
table or query. You may have to re-add all of the controls/fields on your
form or change their data sources as well.
Instead, why don't you just create a brand new form using the Form Wizard
and select your table or query as the data source?
T
Tobie
Thank you I will just try that instead.
Rick B said:Then go into the data source, click the drop-down there, and select your
table or query. You may have to re-add all of the controls/fields on your
form or change their data sources as well.
Instead, why don't you just create a brand new form using the Form Wizard
and select your table or query as the data source?
T
Tobie
I had to re-add alot of the fields again. It is working now and wanted to
say thank you.
say thank you.