Table - missing data

  • Thread starter Thread starter Beeyen
  • Start date Start date
B

Beeyen

Good Day,

I have a number of combo boxes in my form and I can make selections from the
drop-down, save the record and everything is fine. When I go to view my
table, with the exception of the fields that does not have tables, I can only
view the auto number key in the field and no information. I am thinking I
must have the table set-up incorrectly in the table storing the form
data-entry. Has anyone encountered this and could you please provide some
assistance?
 
How would you suggest, I verify information entered into the form is correct?
I have not seem it where a name, save from an entry select in a form is
returned as a number in the table field
 
How would you suggest, I verify information entered into the form
is correct?
Click to expand...

Knowledgeable users create a form gfor this piurpose.
I have not seem it where a name, save from an entry select in a
form is
returned as a number in the table field
Click to expand...

Knowledgeable people do not use autonumbers as keys into tables when
a natural key exists.
 
If you open your form in design view and check the properties of the combo
you will see that Bound Column is one but the Column Widths will look
something like 0"; 1.5" or possibly three widths. The first shown as 0"
will not show the bound column that gets store in the table. The next is
what the combo displays.
 
Back
Top