Feild Lists

[Guest]

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??

 

[Douglas J Steele]

Your question doesn't make sense. WHAT field list is "completely different
from the form"?

 

[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.

 

[Guest]

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.

 

[Guest]

That I can see no underlying data source. The form is not based on a query.

 

[Rick B]

If the form is unbound, then there will be nothing in the field list. You
are confusing me.

 

[Guest]

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.

 

[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?

 

[Guest]

Thank you I will just try that instead.

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?

 

[Guest]

I had to re-add alot of the fields again. It is working now and wanted to
say thank you.