Desperately dying on simple problem-Field not on Control Source

[Guest]

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[Guest]

in properties click on control source and choose your new field, on row
source type choose value list, on row source type in your choices with ";"
for text and ; for numeric.
I hope that helps.

 

[Guest]

foxydev77,

Unfortunately this did not resolve my issue.

Did what you said:

1. Open Form in Design
2. Right-click on the Combo Box and choose Properties
3. On Control Source choose ...
4. Located on the far left hand corner the new field from the table
5. Double-click to add to expression box on top then hit ok
6. Saved the form and then tried to update a record

The values from the combo box value list established on the table are
present but I am unable to select a record.

In the lower left hand corner of the form I receive this message:

'Control cannot be edited it is bound to the expression Issues!.Resolved'

Issues is the table name, Resolved is the new field name.

in properties click on control source and choose your new field, on row
source type choose value list, on row source type in your choices with ";"
for text and ; for numeric.
I hope that helps.
--
thanks,
foxydev77

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[Guest]

I just re-read your prob.
The old table (without new field) is showing up. Be sure to save your table
with new field in it. Go to the form and take out table and save. Go back
to form and put in table with new field and save.
Properties for combo box should show the new field for control source.

 

[Guest]

Is it possible your form is based on a query based on the table?
If so, you will first need to add the field to the query. It will then show
up in your field list when you drop down the control source to select a field.

foxydev77,

Unfortunately this did not resolve my issue.

Did what you said:

1. Open Form in Design
2. Right-click on the Combo Box and choose Properties
3. On Control Source choose ...
4. Located on the far left hand corner the new field from the table
5. Double-click to add to expression box on top then hit ok
6. Saved the form and then tried to update a record

The values from the combo box value list established on the table are
present but I am unable to select a record.

In the lower left hand corner of the form I receive this message:

'Control cannot be edited it is bound to the expression Issues!.Resolved'

Issues is the table name, Resolved is the new field name.

in properties click on control source and choose your new field, on row
source type choose value list, on row source type in your choices with ";"
for text and ; for numeric.
I hope that helps.
--
thanks,
foxydev77

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[Guest]

foxydev77,

Thanks I noticed that also when I hit reply. The form needs to be
'refreshed' with the updated table information. I do not understand how to
'take the table' out of the form?

Can you provide steps (as you can see Access is not my strong part)

Thanks

I just re-read your prob.
The old table (without new field) is showing up. Be sure to save your table
with new field in it. Go to the form and take out table and save. Go back
to form and put in table with new field and save.
Properties for combo box should show the new field for control source.
--
thanks,
foxydev77

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[Guest]

That's IT!!!!!

Went into the query of the form and noticed that the Select does not have
that field. Once added it appeared correctly on the form and updated the
underlying table

Thanks

Is it possible your form is based on a query based on the table?
If so, you will first need to add the field to the query. It will then show
up in your field list when you drop down the control source to select a field.

foxydev77,

Unfortunately this did not resolve my issue.

Did what you said:

1. Open Form in Design
2. Right-click on the Combo Box and choose Properties
3. On Control Source choose ...
4. Located on the far left hand corner the new field from the table
5. Double-click to add to expression box on top then hit ok
6. Saved the form and then tried to update a record

The values from the combo box value list established on the table are
present but I am unable to select a record.

In the lower left hand corner of the form I receive this message:

'Control cannot be edited it is bound to the expression Issues!.Resolved'

Issues is the table name, Resolved is the new field name.

in properties click on control source and choose your new field, on row
source type choose value list, on row source type in your choices with ";"
for text and ; for numeric.
I hope that helps.
--
thanks,
foxydev77


:

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[Guest]

Go to properties for 'Form'.
click control source and change table being used.
close properties
click save
open properties for 'Form'
click control source and change to table you need.
click combo box for new field
open properties for 'combo box'
click control source and choose new field.
let me know if you got it.
--
thanks,
foxydev77

foxydev77,

Thanks I noticed that also when I hit reply. The form needs to be
'refreshed' with the updated table information. I do not understand how to
'take the table' out of the form?

Can you provide steps (as you can see Access is not my strong part)

Thanks

I just re-read your prob.
The old table (without new field) is showing up. Be sure to save your table
with new field in it. Go to the form and take out table and save. Go back
to form and put in table with new field and save.
Properties for combo box should show the new field for control source.
--
thanks,
foxydev77

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

I drag a combo box from the toolbox to the form and walk through the wizard.
The wizard does show the new field on the Access table and I move it over to
the Selected Field column.

Once I complete the wizard my combo box data field is showing as Unbound.

If I go to properties and choose the drop down in Control Source my new
field is not there. If I choose the ... and select

[New Field] the
form doesn't allow the use of the drop down.

I know I am overlooking something...how can I have the new field on the
Access Table show as a Control Source on the existing Form (Bound)

Thanks

 

[John Vinson]

In Access 2003, SP2. Have an existing access database with an input form
that updates an access table.

I added a new field ot the access table as a Text Combo Box with a Value
List option.

I want to add this new field on my existing Access Form.

Open the Form in design view. On the Data tab, the first line is the
form's Recordsource. Click the ... icon by this, and accept Access'
offer to open it as a Query.

Add the new field to the Query, close the query design window, and
accept Access' offer to save it.


John W. Vinson[MVP]