Form not Pre-Populating Correctly

  • Thread starter Thread starter JDB
  • Start date Start date
J

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
 
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

Daryl S said:
JDB -

What is the Row Source for your combo box?

--
Daryl S


JDB said:
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
Click to expand...
Click to expand...
 
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


JDB said:
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

Daryl S said:
JDB -

What is the Row Source for your combo box?

--
Daryl S


JDB said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top