Field List Box

[Jonas]

I have run into a weird situation. I created a form. Then I added a
field to a table. Now I am unable to find the field that I added in
the field list box in the design view for forms. What could I be
doing wrong?

Tyrone

 

[AccessVandal via AccessMonster.com]

Hi,

Because the listbox is not bound to the table name, it will not appear in the
listbox row source.

You'll need to re-create the row source query to include the new field.
Access does not automaticaly insert this new field if the row source is a
custom build query.

Go to the listbox rowsource property and click on the "..." to view and
insert the new field.

 

[AccessVandal via AccessMonster.com]

I forgot to add...

You'll also need to set the format tab - column count property to the correct
number of field in the rowsource query.

 

[Jonas]

I forgot to add...

You'll also need to set the format tab - column count property to the correct
number of field in the rowsource query.

Thanks for the reply. I just double clicked on the box in the upper
left-hand corner to activate the properties window. From there, I
chose the table from the drop down menu that I want to work with.
This process worked without a problem.

 

[AccessVandal via AccessMonster.com]

Hi,

Is that the form's properties or the listbox properties? Ehat I'm refering to
is the listbox properties.

I forgot to add...

[quoted text clipped - 5 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200711/1

Thanks for the reply. I just double clicked on the box in the upper
left-hand corner to activate the properties window. From there, I
chose the table from the drop down menu that I want to work with.
This process worked without a problem.

 

[Douglas J. Steele]

I suspect that the "field list box" to which Jonas is referring is the one
that shows all of the fields in the form's RecordSource (look at View |
Field List from the menu), as opposed to a list box on the form.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi,

Is that the form's properties or the listbox properties? Ehat I'm refering
to
is the listbox properties.

I forgot to add...

[quoted text clipped - 5 lines]

Message posted via
AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200711/1

Thanks for the reply. I just double clicked on the box in the upper
left-hand corner to activate the properties window. From there, I
chose the table from the drop down menu that I want to work with.
This process worked without a problem.

 

[AccessVandal via AccessMonster.com]

Yes, I might have been mistaken.

I suspect that the "field list box" to which Jonas is referring is the one
that shows all of the fields in the form's RecordSource (look at View |
Field List from the menu), as opposed to a list box on the form.