Where is "refresh" button on the field list toolbar?

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

Guest

I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
 
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery
 
In a form.....I am trying to actually get rid of two fields that show up
under "field list" that are no longer in my table. The help section says to
use the refresh command that is on the toolbar, but I can't find the icon
anywhere.

The problem shows up when I want to enter my form and it says "Enter
parameter value" for both of the fields that are no longer in the table. I
believe if I refresh the field list under "design view" that this problem
would go away.

I don't believe your previous solution would help me. I just need to find
the refresh icon on the toolbar, but it's not there!!! Please respond
again if you have a different idea. TIA

Ofer said:
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
Click to expand...
Click to expand...
 
In that case open te form in design view, open the record source of the form,
and remove the two fields form the SQL.

You probably have a select on the two fields that you removed from the
table, the refresh button has nothing to do with it.


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
In a form.....I am trying to actually get rid of two fields that show up
under "field list" that are no longer in my table. The help section says to
use the refresh command that is on the toolbar, but I can't find the icon
anywhere.

The problem shows up when I want to enter my form and it says "Enter
parameter value" for both of the fields that are no longer in the table. I
believe if I refresh the field list under "design view" that this problem
would go away.

I don't believe your previous solution would help me. I just need to find
the refresh icon on the toolbar, but it's not there!!! Please respond
again if you have a different idea. TIA

Ofer said:
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
based on your additional info below, i would definitely turn *off* the Name
AutoCorrect option (see my post elsewhere in this thread). also, is your
form based directly on a table? or on a query? if the latter, check the
query to see if those "deleted" fields are still listed in the SELECT
statement. also, double-check the bound controls in your form, to make sure
none of them is bound to a "deleted" field. and if you have any calculated
controls in the form (where the control's ControlSource property says "=
something"), then make sure that the "deleted" fields are not referenced in
the expression.

hth


Cruiser said:
In a form.....I am trying to actually get rid of two fields that show up
under "field list" that are no longer in my table. The help section says to
use the refresh command that is on the toolbar, but I can't find the icon
anywhere.

The problem shows up when I want to enter my form and it says "Enter
parameter value" for both of the fields that are no longer in the table. I
believe if I refresh the field list under "design view" that this problem
would go away.

I don't believe your previous solution would help me. I just need to find
the refresh icon on the toolbar, but it's not there!!! Please respond
again if you have a different idea. TIA

Ofer said:
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Thank you...... that worked fine. There are so many things to learn. I am
very glad for a board like this. Thanks again.

Ofer said:
In that case open te form in design view, open the record source of the form,
and remove the two fields form the SQL.

You probably have a select on the two fields that you removed from the
table, the refresh button has nothing to do with it.


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
In a form.....I am trying to actually get rid of two fields that show up
under "field list" that are no longer in my table. The help section says to
use the refresh command that is on the toolbar, but I can't find the icon
anywhere.

The problem shows up when I want to enter my form and it says "Enter
parameter value" for both of the fields that are no longer in the table. I
believe if I refresh the field list under "design view" that this problem
would go away.

I don't believe your previous solution would help me. I just need to find
the refresh icon on the toolbar, but it's not there!!! Please respond
again if you have a different idea. TIA

Ofer said:
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


:

I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Hi,
I have a similar problem like Cruiser has. I just cannot find this "refresh
icon on the toolbar" which is described in the official Access-Documenation.
I checked all available buttons but could not find this "official" button.
My problem is, that I included a new field in a table, but this new field is
not shown in the field list. The documentation says, that the field list
needs to be opened and then the refresh button needs to be pressed. Can
somebody help where this button is ?

Thanks a lot in advance.


Ofer said:
In that case open te form in design view, open the record source of the form,
and remove the two fields form the SQL.

You probably have a select on the two fields that you removed from the
table, the refresh button has nothing to do with it.


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


Cruiser said:
In a form.....I am trying to actually get rid of two fields that show up
under "field list" that are no longer in my table. The help section says to
use the refresh command that is on the toolbar, but I can't find the icon
anywhere.

The problem shows up when I want to enter my form and it says "Enter
parameter value" for both of the fields that are no longer in the table. I
believe if I refresh the field list under "design view" that this problem
would go away.

I don't believe your previous solution would help me. I just need to find
the refresh icon on the toolbar, but it's not there!!! Please respond
again if you have a different idea. TIA

Ofer said:
Create a button on your form, and on the OnClick event of the button enter
the code

Me.[List box name].Requery


--
The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck


:

I am trying to refresh the "field list" in a Access Form. I have searched
all over for the refresh command or button. It's not in any of the toolbars.
I know what it should look like, but don't see it. Please help.

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
I have a similar problem like Cruiser has. I just cannot find this
"refresh
icon on the toolbar" which is described in the official Access-Documenation.
I checked all available buttons but could not find this "official" button.
My problem is, that I included a new field in a table, but this new field is
not shown in the field list. The documentation says, that the field list
needs to be opened and then the refresh button needs to be pressed. Can
somebody help where this button is ?
Click to expand...

There are several bad things happening here:

1. Wrong newsgroup. This is for Microsoft Access, the database program
that ships with Microsoft Office, and your question does not seem to apply.
Further, you do not even identify the program you are using.

2. Off the top of my head, try a right-click on the blank portion of
your toolbar and see if there is a "cusomize" command that lets you invoke
the functionality that you seek.

3. Often, in database products, if you add a "field" or "column" after
already having created an input or output view, you must do some tinkering
to connect the new stuff to your input form or output report.
 
The documentation is talking about Data Access Pages. Are you using a Data
Access Page?
 
Hi Brendan,

just a short description what I did:
I created 2 tables with fields in it. Then I created a form with these 2
tables. Afterwards I included a new field in one of the tables and now I
would like to make the new field visible in the already existing form.
However I cannot see the field and I do not have a chance to refresh the
fields.
 
Siddhartha68 said:
Hi Brendan,

just a short description what I did:
I created 2 tables with fields in it. Then I created a form with
these 2 tables. Afterwards I included a new field in one of the
tables and now I would like to make the new field visible in the
already existing form. However I cannot see the field and I do not
have a chance to refresh the fields.
Click to expand...

Your form is a based on a query (created by the wizard) and you need to modify
that query to add the new field.

Open form in design view and on the property sheet find the RecordSource
property and press the builder [...] button to the right of it. Once in the
query designer, add the new field, then close and save.
 
Rick,

thanks a lot for your help !

Rick Brandt said:
Siddhartha68 said:
Hi Brendan,

just a short description what I did:
I created 2 tables with fields in it. Then I created a form with
these 2 tables. Afterwards I included a new field in one of the
tables and now I would like to make the new field visible in the
already existing form. However I cannot see the field and I do not
have a chance to refresh the fields.
Click to expand...

Your form is a based on a query (created by the wizard) and you need to modify
that query to add the new field.

Open form in design view and on the property sheet find the RecordSource
property and press the builder [...] button to the right of it. Once in the
query designer, add the new field, then close and save.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where is "refresh" button on the field list toolbar? 5
Unable to Refresh Fields in Field list 7
subform-on Main form not refreshing queried job list 2
subform will not refresh 6
Refreshing Data Form in a Tab 1
form still on task bar 1
List box - Detect changed value 1
Refresh Button 1

Back
Top