Field List

[Neo90815]

Hi

My form is based on a Query. I added couple of fields to my table and have also updated my Query too. For some reasons, the new fields are not displaying on my form under Field List.

I just wanted to added new fields to my form. Anyone has any suggestions.

Thanks!

 

[tariqshah]

Hi,
Have you put the query field as the control source for the field in the form?

Tariq

 

[Neo90815]

No, I can't see the new fields in the form to add it to Control Source.

My form is based on a Query. I had no problem updated the Query with the new fields but it would not show up in the Field List; if so I can drag and drop it onto my form.

Thanks

 

[R. Hicks]

Try opening the query without using the form by going to the query tab, highlighting the query, then click on open. I suspect that the query does not contains the new fields even though you say you "updated" the query.

To add the new field to the existing query:

Open query in design view, drag the field from the table to the field section in the lower section of the window. You should then see this field along with the other previous choices.

HTH
RDH

[This message has been edited by R. Hicks (edited 08-10-2000).]

 

[Neo90815]

Thanks R. Hicks,

I did the drag and drop option and the fields are there and are checked to show but they are not available for use in my form.

In recap of problem: I created several tables. I created a query based on two tables only. Then I created my form based the query. Now, I just added couple of fields to one of the two tables. I updated my query to shows those field and be avaible for use in my form..BUT BUT it not there. I am using Access 2000 & under View Menu | Field List shows all availble fields and this is where my new created fields suppose to be.

There gotta be a way to add additional fields after creating a form..

Any feedback is greatly appreciated...Thanks

 

[Neo90815]

Thanks to all who reply to my post. Problem has been resolved. Access 2000 or Access is working consistenlty.

I tried the method to another .mdb and added a field on a table.. show in a query.. went to my form and the new field is avaible for use. Now I just need to find some why to have the application work consistently.