Form not Pre-Populating Correctly

[JDB]

I have a table and a form. The form has an unbound combo box (row source a
query) for looking up records - once a record is selected the form populates
with that record's fields.

This was all working swimmingly, until I added a new text field
[ProgramYear] to the table. For existing records, I entered values for
[ProgramYear] in the table. I added a value list combo box [cboProgramYear]
to the form to allow users to select a value for new records.

The problem is this - when I open the form, [cboProgramYear] does not show
the existing contents (which should be either 'PY08-09' or 'PY09-10').
Rather, it shows either '0' or a '-1' which, because i have many other fields
enabled based on that field, really screws things up.

Any suggestions? Thanks

 

[Daryl S]

JDB -

What is the Row Source for your combo box?

 

[JDB]

the row source for the unbound combo box is a query.

the row source for [cboProgramYear] is a list typed into the property sheet
row source field: "PY08-09";"PY09-10";"PY10-11"

Thanks

JDB -

What is the Row Source for your combo box?

--
Daryl S

I have a table and a form. The form has an unbound combo box (row source a
query) for looking up records - once a record is selected the form populates
with that record's fields.

This was all working swimmingly, until I added a new text field
[ProgramYear] to the table. For existing records, I entered values for
[ProgramYear] in the table. I added a value list combo box [cboProgramYear]
to the form to allow users to select a value for new records.

The problem is this - when I open the form, [cboProgramYear] does not show
the existing contents (which should be either 'PY08-09' or 'PY09-10').
Rather, it shows either '0' or a '-1' which, because i have many other fields
enabled based on that field, really screws things up.

Any suggestions? Thanks

 

[Daryl S]

JDB -

I assume the data in the table is OK, and that you are struggling with what
you see in the combo box. Check the properties of the combo box. It could
be the column widths are too small or there is something in the Format
property that is causing the problem. Also make sure the row source is
correct.

Is the data correct in the database if you select one of the options?

--
Daryl S

the row source for the unbound combo box is a query.

the row source for [cboProgramYear] is a list typed into the property sheet
row source field: "PY08-09";"PY09-10";"PY10-11"

Thanks

JDB -

What is the Row Source for your combo box?

--
Daryl S

I have a table and a form. The form has an unbound combo box (row source a
query) for looking up records - once a record is selected the form populates
with that record's fields.

This was all working swimmingly, until I added a new text field
[ProgramYear] to the table. For existing records, I entered values for
[ProgramYear] in the table. I added a value list combo box [cboProgramYear]
to the form to allow users to select a value for new records.

The problem is this - when I open the form, [cboProgramYear] does not show
the existing contents (which should be either 'PY08-09' or 'PY09-10').
Rather, it shows either '0' or a '-1' which, because i have many other fields
enabled based on that field, really screws things up.

Any suggestions? Thanks